I have a bunch of markets that I have created groups for them grouping them by region. I have also created a bunch of calculations (sales and whatnot)
If I have just the groups in my rows and my calculations in my columns, the markets are summarized in their group correctly.
If I have just the markets in my rows and my calculations in my columns, each market is summarized correctly.
What I want to do is display both in one worksheet. Eventually I will be building Dashboards, so if that is my only option, I could go that route. Thought I don't know how.
Any help is appreciated.
I figured it out. Do the following:
Analysis > Totals > Add all Subtotals.