top 10% by rank

[sabmaldun4]

Hello everyone,

I try to get the top ten percent of customer by Sales.

There should be a rank function first on which the second function relates to ( I guess.)

I tried with the following solution, but it did not quite work:

= if (aggr(rank(sum(Sales)),Customer)>=0.9*count( total distinct (Customer)),'Top 10%','Bottom')

Anyone of you guys has a solution for it?

Thank you!!!

[sunny_talwar]

Would you be able to share a sample to look at this? Also, it would be helpful to know the expected output based on the sample data provided.