EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB4894: How to enable or disable ’Smart Totals’ for compound metrics in MicroStrategy Developer 9.x


Stefan Zepeda

Salesforce Solutions Architect • Strategy


How to enable or disable ’Smart Totals’ for compound metrics in MicroStrategy Developer 9.x

Smart totals are useful for compound metrics that calculate a 'percentage to total' value. If a compound metric does not use smart totals, the data returned to the report may not make sense.
The smart metric property of a compound metric allows you to change the default evaluation order of the metric. Smart metrics calculate subtotals on individual elements of the compound metric. For example, a smart metric uses the formula Sum (Metric1) / Sum (Metric2) rather than Sum (Metric1/Metric2).
 
To enable or disable Smart Totals in Strategy Developer, follow the steps below:

  • Open the compound metric in the metric editor.
  • Click on the 'Subtotals' tab.
ka02R000000kX61QAE_0EM440000002GH9.gif
  • Select 'Yes or 'No' from the drop down list.
ka02R000000kX61QAE_0EM440000002GHD.gif

 
NOTE: If the above drop down list is disabled, the metric is not a compound metric and so smart totaling does not apply.


Comment

0 comments

Details

Knowledge Article

Published:

April 10, 2017

Last Updated:

April 10, 2017