grand total for report with page set

[marzbuzz]

Hi all,

I have a list report using department as page set. I want to show the grand total for gross wages so I added overall footer in the list. However the grand total is calculated against each department instead of all departments.

Please suggest.

Thanks,
MB

[hespora]

Add a new page without page set. Insert your data without Department query item.

[marzbuzz]

Thanks Hespora. I need to show both department and grand total for gross wages. For each page, I want to see the department total and for the last page I want to see both department total and grand total.

MB