KB8429: How to create a 'Top 10 Contributors vs. All Others' report in MicroStrategy Developer 10.x

Users can create a report which displays the top ten contributors versus all other contributors by use of custom groups. This 'Top 10 Customers vs All' custom group will have two elements. One element will show the top ten customers and another element will show all customers.
 
Using the Strategy Tutorial project, perform the following steps to achieve this:

• The first element will be called "Top 10 Customers" and will be a set qualification on the "Revenue" metric, which is a rank on the top ten, and where the output level is the Customer attribute.
  

• The second element will be called "All Other Customers" and will be a set qualification on the "Revenue" metric, which is a rank that excludes the top ten customers, and where the output level is the Customer attribute.
  

• To display the Top 10 Customers' names, right click on the first custom group element. Choose "Show Display Options" and select the second option ("Show only the individual items within this element"). Since all other customers are not being displayed, it is not necessary to perform this step for the second custom group element.
  

• In order to display the percent contribution of each of the top ten customers, create a "Percent to Total Customers Revenue" metric.
  
  To create this metric, perform the following steps:
  
• Create the percent to total metric by defining it like below:
  

• Place the denominator at the customer level with filtering set to "Ignore" and grouping set to "None":
  

• Change the formatting of the percent to total with the appropriate settings (decimal places, negative value formatting, etc).
• Place the "Top 10 Customers vs All" (as is done with an attribute), the "Percent to Total Customers Revenue", and "Revenue" on the report and the result will as shown in the screen shot below:
  

KB8429