Top / Least 10 in straight table with corresponding total

[#1]

Hi,

I want to display top and least 10 categories (2 charts) based on Sales. I am using straight table to display these results. I can give max number as 10 in the prsentation tab, but the problem is that the Total displaying at the top is still for all categories. Is there any way to display the top/least 10 catgories with the corresponding total. Please look at the attachment.

I tried using rank function, but I am not able to get it work for 2 dimensions.

Thanks.

[#2]

Thanks Nathan.

But unfortunately I need the other dimension (Product) also, because multiple product will have same category and hence the result is wrong. I tried using rank function in dimension, but didn't get it right. Is there any other way of doing it.?

Also, please let me know how to get least 10 categories. Thanks.

[#3]

I got it to work for the top 10 with two dimension. Below is the expression which I have used.

'=IF(AGGR(RANK (Total(sum( {<Range= {'0 - 10', '11 - 20'}>} Sales3 ))),Product, Category)<=10,sum( {<Range= {'0 - 10', '11 - 20'}>} Sales3 ))'.

I need to figure out to work it for least 10 now.

[#4 · Accepted solution]

Atlast, I got the answer right. I am able to get the Top / Least rank. I have attached the result and hope it helps someone.

Thanks.

[#5]

Thanks Santhosh... 🙂

[nathanfurby]