KB413718: Subtotal value is incorrect for a level metric in MicroStrategy 9.x-10.x

SYMPTOM
In Strategy 9.x-10.x, subtotal value does not calculate as expected for a level metric. The subtotal sums up all the metric values instead of displaying the level metric result.
 
STEPS TO REPRODUCE
The following steps are based on the Strategy Tutorial project: 

• Create 2 metrics:  M1=Sum(Revenue){Quarter+}, M2=Sum(Revenue){~+}
• Create a report R1 with attributes Year, Month and metrics M1,M2; to simplify the report, a filter Quarter in list {2010 Q1} can also be added. 
• Execute the report to get data as shown below:
  
  

• After enabling Total in the grid, Total value for M1 is not correct, it should be 1,682,656. However, the values are just summed. 
  
  

• Add attribute Quarter to template; the Total value for M1 is now correct. 
  
  

 
              
CAUSE
This is a known issue with Strategy 9.x.-10.x
 
WORKAROUND
To workaround this issue, one of the following methods can be implemented:
Method 1:

1. Add the metric’s level attribute(s) to the report template.

 
Method 2:

• Create a derived metric DM1 with definition: Sum(M1){Quarter, ~}            

• Enable 'Aggregate from Base' and 'Subtotal from Base' from the metric options

• Execute the report, notice the derived metric total is showing correct aggregation with the Quarter attribute in the report object

 
ACTION
Currently this issue is still being reviewed for feasibility by our Technology team and it is not scoped for any upcoming scheduled Strategy release. 
 
 
The internal reference number for this is DE3628 and 000013718
KB413718