Subtotals, Subtotals and Grand Totals??

[Czeszyn]

Is there a way that say a person wants November and December, then when my report prints it looks like this:

November
number number

December
number number

then a grand total of the column.

My question is, is there a way to have it where November would have its grand total, and so would what every month is asked, in this case December, then on the very bottom it would print out the grand total of it all.

example

November
number number
Subtotal number number

December
number number
Subtotal number number

Grand total number number

Is this possible?

Thank you in advance.
Tony

 

[pbaldy]

Sure, in Sorting and Grouping you can group on the month. In the group footer, the Sum() function will sum up that month, in the report footer it will return the grand total.

 

[Czeszyn]

Thank you very much, that worked. Thank you, thank you.

 

[pbaldy]

Happy to help!