How to limit top 10 by a measure not used in chart

[Anonymous]

I created a bar chart on Customers by Profit but I want to limit the chart to just show top 10 customers by Revenue (which is not used in chart). Any idea how to do that?

Thanks in advance.

[agigliotti · Accepted solution]

I think you should create a calculated dimension.

ex. Aggr( if( Rank(Sum(Revenue)) <= 10, Customer, null() ) )  and uncheck "Include null values" checkbox under dimension.

[qv_testing]

My bad, your right Andrea .

[Anonymous]

Hey I am getting an error in expression. Error says Aggr takes at least two parameters.

[Anonymous]

That was really helpful. This thing worked for me. Thanks,

Aggr(if(Rank(Sum(Revenue)) <= 10, Customers, null()),Customers)

[premacharya0903]

This is great , i can also get the other values clubbed into others , However , how can i sort the values by Revenue in such a way that 'Others' would always be the last bar.