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.
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.
My bad, your right Andrea .
Hey I am getting an error in expression. Error says Aggr takes at least two parameters.
That was really helpful. This thing worked for me. Thanks,
Aggr(if(Rank(Sum(Revenue)) <= 10, Customers, null()),Customers)
Retrieving data ...