Filter a table by the 40 members with the highest turnover

[former_member708541]

Hi Community:

I'm developing a story in which I have 1000 clients and I want a table that shows the 40 clients with the highest turnover only (in descending order). I have created a bar chart showing the 40 clients with the highest turnover and I have tried to do a linked analysis but it does not work. Can you think of a way to solve my problem?

Thank you

[former_member6443 · Accepted solution]

Hi carolina.nieto.ibarzabal,

If you have the Turnover measure in the table / grid and simply highlight the first row and right click and you will see Sort Options and Top N options.

Regards

Afshin

topnoptions.png