best sellers column and filter

[Laocsulak]

Hello,

I have created a simple matrix with the customers and their purchases, like in the next dummy example:

I would like to know if there's a way to add a column and/or a filter that shows who are the 3 top sellers, who are "1", "2" and "3" in this example.

Files:

https://drive.google.com/drive/folders/1HuK9I8zG1F3urpJhjnjxr4L3d15CoAko?usp=sharing

Thanks in advance!

[FreemanZ]

hi @Laocsulak 

try to add a measure to the matrix visual:

Ranking =

RANKX(

    ALLSLEECTED(TableName[buyer]),

    CALCULATE(SUM(TableName[amount]))

)