Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!!
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.