O'Reilly logo

Business Intelligence with MicroStrategy Cookbook by Davide Moraschi

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

Getting ready

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... ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required