I have a table with three fields, Weeknno, Office and Cases. I want to produce a line chart that shows the cumulative total number of cases for each office over the weeks. For example, if I have 3 offices, each office would have a different line represented on the graph showing its growing total number of cases over a period of time. Th einformation is currently stored in a table like:
Weekno | Office | No Cases
01 | London | 26
01 | Paris | 32
02 | London | 14 (cumulative total would be 40)
02 | Paris | 4 (cumulative totla would be 36)
.. and so on...
Is it posssible to do this?