Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
se dimension limit, the second tab of your chart
Hi Aama,
Try,
Use this as Dimension:
if(Aggr(Rank(Sum(Sales),ID)<=25,ID)
Expression:
Sum(Sales)
Regards
KC
for a str table and 25 you can also use max number in presentation tab
here a lot of useful different way
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?
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