I'm sure this has been addressed, but I cannot find the answer that I am seeking. I am trying to have sum totals for categories within a group. Ex:
Location1 Mgmt Active 12
Quit 4
Term 2
Hourly Active 60
Quit 6
Term 7
Location2 Mgmt....
I would like to be able to show a summary on the footer for Location that would show:
Total Active 72
Total Quit 10
Total Term 9
Running sum does not work for this. I can create groupings for each status (Active, Quit, etc.) but I cannot sum up the totals on the location footer.
Thanks in advance for your help.
Location1 Mgmt Active 12
Quit 4
Term 2
Hourly Active 60
Quit 6
Term 7
Location2 Mgmt....
I would like to be able to show a summary on the footer for Location that would show:
Total Active 72
Total Quit 10
Total Term 9
Running sum does not work for this. I can create groupings for each status (Active, Quit, etc.) but I cannot sum up the totals on the location footer.
Thanks in advance for your help.