Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Do you want top 10 IDs in a Text box?
EDIT: =Concat(If(Aggr(Rank(Sum(Volume)),ID)<=10,ID),',')
Provide sample data please.. or look into below example...
HI
'>$(=date(max(Period))-$(vTrendingDays)) this part gives number instead of date.
May be try like this.
'>$(=date(max(Period)-$(vTrendingDays)))
and also check the date format are same with Period date format.
I want Top 10 Volume's.
Just assume above i have given the sample data just like that only i want it.
Top 10 IDs
=Concat(If(Aggr(Rank(Sum(Volume)),ID)<=10,ID),',')
Top 10 Volume
=Concat(If(Aggr(Rank(Sum(Volume)),ID)<=10,Aggr(Sum(Volume),ID)),',')
sum({<ID={"=Rank(Sum(Volume))<=10"}>} Volume)
I don'y want in text object.
I want it in a straight table
Hi Shravan,
Expression with the rank function =rank(expression,ID)
Then on the Presentation tab tick Max Number box and type 10 in the box
Regards
Kamiel
If(Aggr(Rank(Sum(Volume)),ID)<=10,Aggr(Sum(Volume),ID))