multiple rank in a pie chart

[#1]

Can we have multiple rank in a pie chart?

for example, I like to have top 10 customers and 11-20 customers on pie chart with $amount and percentage.

I know how to get top 10 customer with rank and aggr but i can't figure out having both in one chart.

Thanks!

[rwunderlich]

Will setting the "Maximum Number of Slices" (in Presentation) to 10 give you what you need?

-Rob

[#3]

yes, it is the easiest way to get only top 10, but I need top 10 customers in one slice of pie and top 11-20 customers in another slice and Others in third slice.

Ryan

[prieper · Accepted solution]

Should work with a calculated dimension like the below (aircode - not tested)

IF(AGGR(RANK(SUM(Turnover)), Customer) < 10, Customer, IF(AGGR(RANK(SUM(Turnover)), Customer) < 20, 'Customer 11-20', 'Others'))

HTH
Peter

[#5]

Thanks!