KB9688: How to create a custom subtotal using a custom expression in MicroStrategy Developer

The following screen shot displays the default list of Subtotals in Strategy Developer:

However, to create a new custom subtotal, perform the following steps:

• In Strategy Developer, right-click and select "New" > "Subtotal".
• Using the functions in the "Basic Functions" folder in the drop-down box, create a custom subtotal in the Definition window, as shown below:
  

• Save the new subtotal.
  

• Go to "Tools" menu > "Apply to metric", as shown below:
  

• Select the metrics to apply to this subtotal and click OK:
  

• Create a new report with the metric which was selected in Step 5:
  

• Navigate to "Data" menu > "Subtotals".

The Subtotals window will open and a new custom subtotal will appear in the available subtotals list, as illustrated below:
 

 
The report will now reflect the new custom subtotal, as shown in the following screen shot:
 

 
"New Custom Subtotal" is (total of revenue) / 2 = 8,468,217 as the definition of "New Custom Subtotal".