Custom Subtotal Displays in MicroStrategy

Defining custom subtotal displays in MicroStrategy

By default, when users apply subtotals in a report, the name of the subtotal is displayed in the subtotal line items that appear in the report. Users can use custom subtotals to give more control over the characteristics of a subtotal. Custom subtotals allow users to define custom subtotal line items that appear on the reports

 Users can make the subtotal name dynamic by typing special characters in the subtotal name field as listed in the following table.

Character	Description
#A	The name of the attribute under which the subtotal appears.
#P	The name of the attribute to the left of, or above the attribute under which the subtotal appears.
#0	All the forms of the parent element.
#1	The first form of the parent element reading from left to right or from top to bottom.
#2	The second form of the parent element reading from left to right or from top to bottom.
#3	The third form of the parent element reading from left to right or from top to bottom.
#4	The fourth form of the parent element reading from left to right or from top to bottom.

To define a specific subtotal displays for a report like the one shown above, follow the steps below:

1. Select Subtotals from the Data menu. The Subtotals dialog box opens.
2. Clear the Totals check box to remove the standard subtotals.
3. Click Advanced, then New to create a custom subtotal.
4. Type the following for the name: "Total for the #P #0". Remember that P displays the parent attribute and 0 (the number zero, not the letter o) displays all the forms of the parent attribute. In this case, only one form exists for each, as shown below:
   
   
   
   
   
   
5. All the metrics on the report are listed. Users can select the subtotal function to use for each. Total is correct for all of the metrics.
6. Click OK to save the new subtotal.
7. Click OK to return to the Subtotals dialog box.
8. Click OK.

The report now should look like this: