Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
Will setting the "Maximum Number of Slices" (in Presentation) to 10 give you what you need?
-Rob
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
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
Thanks!