KB5232: How to create custom subtotals for metrics in a report in MicroStrategy Developer 9.4.x - 10.x

Custom totals can be used to selectively display subtotals for different metrics in Strategy Developer, as shown in the report below:

 
Custom subtotals can be configured from the Report Editor.

• Right-click on the report and choose 'Edit'.
• Choose Data > Subtotals.
• Choose 'Clear All' and choose 'Advanced' in the Subtotals window.
  

• Choose 'New' from the Advanced Subtotals Options window.
  

• Name the custom subtotal.
  

• Choose how the metric subtotals should be displayed in the Custom Subtotal Properties window.
• Choose what type of total display is desired for each individual metric in that specific report.
  
• Choose what type of total display is desired for all metrics under 'Reset all metrics subtotals to:' and click on 'Reset'.
• Click on 'OK' to save.
  

• Set the Subtotal Application Level for each Subtotal type and click on 'OK' from the Advanced Subtotals Options window.
• Make sure the subtotal definition created is selected from the Subtotals window and click on 'OK'.