largest 5 values in staright table

[#1]

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

[harishkumarg]

The above solution worked for you?

Regards

Harish

[#3]

Hi hariah i will try it and let u know

[Anonymous]

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,

[hemachandran]

Hi cena,

Try this expression,

=if(max(total) = max(total <region> total),max(total <region> total))

[beck_bakytbek · Accepted solution]

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

[#7]

Hi beck it solved my problem to some extent

Still im facing some issue

[#8]

Hai beck it resolved thank you so much u saved my time

[#9]

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

[#10]

Have you considered what should happen if the same regions have the same highest value?

[#11]

No