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]

This is something I need to do in the future for upcoming reports.

Anyone got ideas?

[#3]

If I've read this correctly, all you need to do is click once on Sales1, then right click over it, and select Sort.

This moves the Sort from the Product to the Sales1 column and allows you to sort ASC or DESC.

Hope this helps.

[#4]

Kindly use this function, it will work..

sum({<Vendor={"=rank(sum(Amount))<=10"}>} Amount)

[#5]

Graeme, my concern is about getting top/least 10 categories. I agree sorting gives the desired result, but not for the top/least 10.

[#6]

Thanks Ankit for the reply. Unfortunately, I am not able to get the things right. Can you please explain with the example I have posted.

[#7]

If you want to display top 10 categories, you can use rank(expr) function in order to restrict them to display top 10 results.

[#8]

I tried using rank function, but ynable to get it right. I have two dimension (Product & Category). There are multiple products having the same category. So, i am not able to get the top 10 with the correct 'total' displayed.

It will be great, if you can look at the attached QVW file in the original post.

[#9]

Can someone please help me out....

[nathanfurby]

Hi Santhosh. Take a look at the attached file.

Sorry, but I did not have time to get it working with the two dimensions Product and Category, so removed Product to simplify things and maybe get you going on finding an answer.