Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
i have a straigt table where i want to display largest 5 values
when i'm making the dimension limits to largest 5 its not working
and the values are showing like this
region | country | total |
a | IND | 22 |
b | VNM | 33 |
c | BGD | 2 |
c | VNM | 34 |
d | ARE | 2 |
d | BRN | 12 |
d | CHN | 8 |
d | IND | 533 |
d | MYS | 12 |
f | LKA | 84 |
f | MYS | 232 |
f | SGP | 2 |
i want the output as below
a | IND | 22 |
b | VNM | 33 |
c | VNM | 34 |
d | IND | 533 |
f | MYS | 232 |
The above solution worked for you?
Regards
Harish
Hi hariah i will try it and let u know
Hi John,
Try following,
Dimension1-- region
Dimension2-- country
Expression--max(aggr(sum(total), region)).
Its working for me and giving following output after setting dimension limit 5
region | country | max(aggr(sum(total), region)) |
---|---|---|
a | IND | 22 |
b | VNM | 33 |
c | BGD | 36 |
d | ARE | 567 |
f | LKA | 318 |
Thanks,
Hi cena,
Try this expression,
=if(max(total) = max(total <region> total),max(total <region> total))
Hi John,
try this:
Calculated Dimension: if(aggr(rank(sum(Total)),Country)<=5,Country, Null())
and dont Forget to check: Suppress When Value is Null
i hope that helps
beck
Hi beck it solved my problem to some extent
Still im facing some issue
Hai beck it resolved thank you so much u saved my time
Can u please help me out in this
Alternates states to compare highest 5 values in current month to the same values in previous month
Have you considered what should happen if the same regions have the same highest value?
No