Top 100 customers ranked by 2 or more measures

[HenkLategan]

Hi All,

I would like to display only the top 100 customers in a chart based on the sum of two of my measures (circled in blue in attachment). 

Please help. 

[Lauri]

I think the only option is to add a new measure to your table, right after the customers dimension, that is a sum of the two measures. (I just tried hiding the new column by entering 1=0 in "Show column if" but then the Top 10 calculation stops working, so no good.)

[HenkLategan]

Is there a way to add another measure, but not display it in the graph? I have attached a picture of what the graph currently looks like so you can see why the split between the 3 measures is needed. 

[Mauritz_SA]

Hi Henk

I am replying to your original question. You can try something like this for your dimension:

=Aggr(ONLY({<[Dimension] = {'=Rank([Measure 1] + [Measure 2])<=100'}>} [Dimension]),[Dimension])

You can just replace [Dimension], [Measure 1] and [Measure 2] with your original dimension (for example Client) and two measure formulas (for example Sum(Sales) and Sum (Outstanding Sales)).

Hope this helps.

Regards,

Mauritz