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,

[krishnacbe]

Hi,

You can use a Input Control with Auto Populated Value like 5, 10, 15.

Use the variable value in Dimension Limit. To filter the selected top values.

[krishnacbe]

[Anonymous]

Can you please provide me further details on how to do it?

[Anonymous]

I did that, but it's not affecting the chart, should I do something else?

[krishnacbe · Accepted solution]

Find the attached sample.

[krishnacbe]

In Chart you need to set as below

[neelamsaroha157]

You have to call this variable in your table, dimension limit tab.

[Anonymous]

Thank you very much for your help on this. I am not seeing the dimension limit's tab in the Pivot table, how can I apply it there?

[neelamsaroha157]

It is available only in straight table.