Business Intelligence with MicroStrategy Cookbook

The bottom line – customizing subtotals

It all eventually boils down to a bottom line. With MicroStrategy, you have the option to add several totals and subtotals and have fairly detailed control over them. In this recipe, we'll see how to add grant totals, subtotals, and custom totals.

Getting ready

Say that you have a report like the one in the image:

You can use the 18 Dynamic Aggregation by Country and Product report we created in the previous recipe and modify it. If you want to simply add a total on the last line, you'd select the Data | Grand Totals menu or press F11; if you want to add subtotals by Product Category, read on.

How to do it... ...