Rank basis on Absolute value but display Positive/Negative number in table

[Saurabh07]

Hello Gurus,

I have mentioned dataset:

Country	Value
India	-7854
Japan	-7662
Korea	6589
China	6541
Germany	-6102
France	5028
Italy	4036
Australia	3521
Netherlands	-2258
Denmark	1975

I want to pick Top 5 countries on basis of highest value. But my condition is, the ranking should be done considering the absolute value but while displaying the value in table it should display the original (positive/negative) number.

Any help on this requirement would be highly appreciated!

[MayilVahanan · Accepted solution]

HI @Saurabh07 

May be try like below

Dim:

=Aggr(If(Rank((if(Sum(Value)<0, Sum(Value)*-1, Sum(Value))))<=5, Country),Country)

Measure1: Sum(Value)

Measure2: Rank((if(Sum(Value)<0, Sum(Value)*-1, Sum(Value))))

[Saurabh07]

@MayilVahanan this worked, thank you so much!!!!

[Akbar]

thank you 🙂