Group by top N

[Anonymous]

Hi

I want to create a pie chart with my top 100 customers by sales grouped in a slice and rest customers as another slice. And show the percentage of total sales for the two groups. Let's suppose my data have customer ID and sales amount as two fields. Is there a way to create such as pie with chart expression rather than load script?

I'm trying to create an dimension like this, but it doesn't work...

if(rank(aggr(sum(Sales),[Customer ID]))<100,'Top 100','Other')

Thanks

Yvonne

[johnw · Accepted solution]

I think just rearrange a bit?

aggr(if(rank(sum(Sales))<=100,'Top 100','Other'),[Customer ID])