Rank?

[#1]

Hi Folks,

I have a Fileds like below.

ID,Name,Volume is (sum(Volume))

here I want top 10 ID's only who is having max volume

Rank-- ID-- Name--  Volume

1         5     D           500

2         9     X           470

3         8     Y           420

----------------------------------

10       2      C          301

I want top 10 ID's Please help me in this?

I tried this it's not working

rank(sum({<Period = {'>$(=date(max(Period))-$(vTrendingDays)) <=$(=date(max(Period)))'},day={'Y'}>} Volume))<=10

[#2]

Hi

why don't you simply use "Dimension Limits" tab, and set only 10 values based on sum(volume) expression ?

best regards

Chris