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...
Forum Discussion
Don,
Thanks for trying. The Summary Report and the table report seem to look pretty much the same once you do the sort and group.
You get subtotals per User-City, but you do not get the subtotal per User after adding the group by City.
Chris
------------------------------
Chris Sipes
------------------------------
Thanks for trying. The Summary Report and the table report seem to look pretty much the same once you do the sort and group.
You get subtotals per User-City, but you do not get the subtotal per User after adding the group by City.
Chris
------------------------------
Chris Sipes
------------------------------
Chris,
You are correct. The subgroups do give you the granularity but they eliminate the higher totals.
Are you interested in a Tableau or PowerBI solution?
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
You are correct. The subgroups do give you the granularity but they eliminate the higher totals.
Are you interested in a Tableau or PowerBI solution?
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
- Too much hard sell for me.
------------------------------
Chris Sipes
------------------------------