Beyond showing the values from calculations, sometimes, we also want to show the values of the totals or subtotals in the same window as these values.
For instance, we have the following graph for SUM(Sales) split by Category and Sub-Category across segments:
Now, if we want to add the subtotals and the grand totals for both rows and columns, we can do the following:
- Go to Analysis > Totals.
- Select Show Row Totals | Show Column Totals. This will show the graph as follows:
- Now if we want to see the subtotals ...