SkiNLaB
Apr 30th, 2006, 09:54 PM
I pass a series of dates with figures for each date.
I need to graph the cumulative totals of these figures across the dates.
Date Example.
Date | figure1 | figure2 |
------------------------------------
'2006-04-01' | 10 | 15 |
'2006-04-02' | 20 | 45 |
So my graph would have '2006-04-02' with a figure1 value of 30 and figure2 value of 60, because it is the CUMULATIVE total.
Any ideas? I tried running totals, but they don't work too well with graphs since the graph can only be printed at the very start or end, and running totals only really work with repeating detail sections...
Any help much appreciated!
I need to graph the cumulative totals of these figures across the dates.
Date Example.
Date | figure1 | figure2 |
------------------------------------
'2006-04-01' | 10 | 15 |
'2006-04-02' | 20 | 45 |
So my graph would have '2006-04-02' with a figure1 value of 30 and figure2 value of 60, because it is the CUMULATIVE total.
Any ideas? I tried running totals, but they don't work too well with graphs since the graph can only be printed at the very start or end, and running totals only really work with repeating detail sections...
Any help much appreciated!