KB19634: Subtotals do not display correctly for a metric on a MicroStrategy 9.4.1 and 10.x report

SYMPTOM
When a user executes a report and places a subtotal on a metric, no total value is generated, as shown for the "Average" subtotal in the screenshot below:

 
CAUSE
One possible reason is that a subtotal will not be calculated if the metric is not configured to allow the use of that subtotal function. Not all subtotals are logical for all metrics. An example may be a count for an "Ending on hand" or EOH inventory metric.
 
ACTION
Modify which subtotals are available for an individual metric by performing the following steps:

1. Opening the metric in the editor.
2. Choose the 'Subtotals/Aggregation' tab.
3. Move all applicable subtotals from the left-hand side (Subtotals available in the project) to the right (Subtotals available for the metric), as shown in the screenshot below:

 
KB19634