Showing top 10 by button

[priyarane]

Hi Community Team,

I have requirement like below

I wanted to show top 10 countries by button

I created a Pivot table in that dimension is Country and expression1 - sum(sales), expression2 - sum(sales1) - expression 2 used for only sorting and its hidden in presentation tab.

so, once I click on button then top 10 countries should show.

Please help me.

[Anonymous]

Sorry..not clear..I thought you already sorting (country) using an expression..

[#3 · Accepted solution]

Hi Priya,

I tried a different approach and it is working for me.

Please find the attached qvw hope it will help you.

Thanks,

Harika

[Anonymous]

Hi Priya,

You can sort the Country column by Sales.

Create a variable and set its value in Action tab of the button. Then set the Dimension limit in your chart.

And your Top3 values would be

Hope this what you are looking for!

Regards,

Laxmi