Sum at the end of each page
Posted by Page sum on April 23, 2001 9:20 PM
Is it possible to create a cumulative sum at the beginning and at the end of each page automatically? I have a long list of values and I'd like to create something like this:
Item 1 $567
Item 2 $666
...
Total sum of this page: $xxx
--- Page break ---
Cumulative sum from previous pages: $yyy
Item 123: $555
Item 124: $666
...
Total sum of this page: $zzz
--- Page Break ---
Since the list is quite long, I'd like to avoid manual work.
Francisco
Posted by Dave Hawley on April 23, 2001 9:47 PM
Hi Francisco
Have you had a look at Subtotals. This can be found under Data on the main Menu. Or perhaps even a Pivot table, also found under Data.
With a Pivot Table you may be better of using a Dynamic range for the source data. You can see some examples of these on my Website under "Dyanamic Ranges"
Dave
OzGrid Business Applications
