Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I would like to create 4 text boxes
in each text box I would like to individually Rank them according to the sum of the sales value using a dimension Category
I would need to display the name of the category in one text box overlaying the text box with the sum.
how can I achieve this...
Fields are Category, Value
Ive used the below to get the name of the highest category... but how would i get the 2nd highest... etc
FIRSTSORTEDVALUE (Category,-Aggr(sum(Value),Category))
ive used this to get the highest number
it seems to be working... but how would i get the 2nd highest etc ...
Max (Aggr(sum(Value),Category))
Appreciate your assistance
Try the following
Object1
FIRSTSORTEDVALUE (Category,-Aggr(sum(Value),Category)) & CHR(13) &
Max (Aggr(sum(Value),Category))
Object2
FIRSTSORTEDVALUE (Category,-Aggr(sum(Value),Category),2) & CHR(13) &
Max (Aggr(sum(Value),Category),2)
Object3
FIRSTSORTEDVALUE (Category,-Aggr(sum(Value),Category),3) & CHR(13) &
Max (Aggr(sum(Value),Category),3)
Object4
FIRSTSORTEDVALUE (Category,-Aggr(sum(Value),Category),4) & CHR(13) &
Max (Aggr(sum(Value),Category),4)
Try below
FIRSTSORTEDVALUE (Category,-Aggr(sum(Value),Category),2)
FIRSTSORTEDVALUE (Category,-Aggr(sum(Value),Category),3)
Regards
ASHFAQ
Why not just using a chart? Same result, more elegant way.
Try the following
Object1
FIRSTSORTEDVALUE (Category,-Aggr(sum(Value),Category)) & CHR(13) &
Max (Aggr(sum(Value),Category))
Object2
FIRSTSORTEDVALUE (Category,-Aggr(sum(Value),Category),2) & CHR(13) &
Max (Aggr(sum(Value),Category),2)
Object3
FIRSTSORTEDVALUE (Category,-Aggr(sum(Value),Category),3) & CHR(13) &
Max (Aggr(sum(Value),Category),3)
Object4
FIRSTSORTEDVALUE (Category,-Aggr(sum(Value),Category),4) & CHR(13) &
Max (Aggr(sum(Value),Category),4)
Thanks Asfaq ..
what about the value?
Thank you very much!