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.

[priyarane]

Hi,

Please check my requirement as attached

[priyarane]

Hi,

Please check my requirement as attached

[sunny_talwar]

Is this what you are looking for?

PFA

Best,

Sunny

[maxgro]

for top 3, vVar

='(' & concat(if(aggr(Rank(Sum(Sorting)),Country)<=3,Country), '|') & ')'

button:selectin field

='$(vVar)'

as in my previous post

[priyarane]

Hi Massimo,

Its working but my requirement is 2 buttons

1st button - 3

2nd button - 4

like that

[Anonymous]

See the attached , just a different approach. Instead of the buttons I loaded your top value selections using inline. see if this works.

[maxgro]

what about adding another variable for top 4? just replace in new variable <=3 with <=4

[priyarane]

even I create 2 variables added action to 2 buttons

but problem is here,

I can select top4 and top 3 button

but I can't select top3 and top4

like attached

[priyarane]

Its good approach,

But i need to put action on sorting only expression, it will be hidden.

[priyarane]

I am not getting you