Top n values

[#1]

Hi,

I have a straight table. I wish to display top 25 records based on the expression values.

e.g. Dimenion is ID

Expression is Sum(Sales).

How do i display top 25 records based on the expression?

[alexandros17]

se dimension limit, the second tab of your chart

[jyothish8807]

Hi Aama,

Try,

Use this as Dimension:

if(Aggr(Rank(Sum(Sales),ID)<=25,ID)

Expression:

Sum(Sales)

Regards

KC

[maxgro]

for a str table and 25 you can also use max number in presentation tab

here a lot of useful different way

Show Top Performers

[#5]

Hi,

In my straight table, i am having two dimensions ID and Group.

Expression is: sum({<DateYr={'2014'}>}Sales)

How do i display to 25?

Do i have to use dimension limits for both the dimensions?

[#6]

Hi Asma,

You can use it on the first dimension ID, to see the Largest 25 Sales irrespective of Group.

If you want to see largest 25 in each top 25 ids you can use dimension limit on both ID and Group

Thanks,

Shruthi Reddy