TOP 5 values in straight table

[Edytagra]

Hi guys,

I am struggling to solve the issue with showing only five highest values in QS.

I have a table as below ( with more positions of course):

[Country name]	Sum([Quantity in KG])
Ukraine	25 222 333
Germany	25 169 321
France	15 322 364

I fund command which i thought is helpful to ranka values and unfortunately it does not work:

Rank(Aggr(Sum([[Quantity in KG]]]), [[Country name]]]))

then I wanted to show just TOP 5 values and cannot find good solution.

Any suggestions?

[JordyWegman · Accepted solution]

Hi Edytagra,

Try to make it a bit easier. Go to your dimension and show TOP, then enter 5 and exclude others.

See example:

Jordy

Climber

[Edytagra]

Thank you very much. I got it but cannot sort it. I choose  sorting via value from highest to lowest and table does not show it correctly.