Use same Top 10 limit in a chart for the main and alternative measure

[acholchemit]

I have a chart and I would like to show two measures main and alternative but use the same Limit totals for both measures.

The measures would be

1. Total measure value (The limit total is based on this measure)

2. Average measure value

The effect would be we see the same Customers and be able to swap between the measures.  In my chart this isnt working when I choose the alternative measure it loses the top 10 ranking and so shows a different set of Customers.

Is this possible?

[lironbaram · Accepted solution]

HI 

the built in top function always use the active dimension 

for your requirement you can use a calculated dimension 

aggr(if(rank(Total measure value)<=10,CustomerName),CustomerName)

[acholchemit]

Worked like a charm, thankyou.