Is there a way to create a filter for Top 5, Top 10, Top 15, etc?

[Anonymous]

Hi,

I have a chart like the following:

it's displaying all the records and it's sort properly. I want to know if there is a way that I can add a filter (multibox) where I can add values as Top 5, Top 10, Top 15, Top 20, etc. So, when the user click on them, the chart will display only the top selected.

Please let me know. Thanks,

[neelamsaroha157]

If you want to use pivot table then you'll need to handle this with expression using aggr and rank.

[Anonymous]

Can you show me how to do it with aggr and rank?

[neelamsaroha157]

If(rank(Count(DISTINCT id))<=vTopBox, Count(DISTINCT id)).

If you have more than one dimension then you need to use aggr.

[krishnacbe]

Check attached.