Subtotal and then subtotal again
I have a table report and have set it to sort and group on my users' names and that works great. It summarizes the data for each user and gives me a subtotal for each user and the total for all users at the bottom.
I would like to get some greater granularity, and add a sort and group by city for each user. I would like the report to have a subtotal for each person in each city and then the subtotal for each person in all cities he or she has.
When I add the second "sort and group by", I lose the total per person. Is there another way to do this so that I can have both subtotals?
------------------------------
Chris Sipes
------------------------------
I would like to get some greater granularity, and add a sort and group by city for each user. I would like the report to have a subtotal for each person in each city and then the subtotal for each person in all cities he or she has.
When I add the second "sort and group by", I lose the total per person. Is there another way to do this so that I can have both subtotals?
------------------------------
Chris Sipes
------------------------------
