When it comes to doing grand totals of aggregates, a lot of times it's easier to create a separate total sheet and place it abutting your data sheet on a dashboard.
Book2_v10.2.twbx 41.3 KB
1 of 1 people found this helpful
What I did in there:
Sheet 2(2) is a copy of the original. I created all my own total calcs and placed them on the sheet next to the original data. (You can see that the Total of Revenue is correct now.)
Copy (3): I took off the original data fields and just left my totals. I did Right click on the [Area] pill and turned off "Show header" because we don['t want to see the area values. I added "Grand Total" as a row pill, and you can see how that looks there. (You can format that however you want.)
Copy (4). We have to have the 4 areas on the sheet so that we get the individual Revenue values, so that's why there are 4 rows. But we only need one of them. So I created a calc called [index], and used that as a filter just to display the first row. And there is your grand total sheet. Placed them on the dashboard as you see in Dashboard1.
Thanks much Joe, it worked.