Top n selection by using slider.

[deepakqlikview_123]

Hello All,

Please find attached screen shot.

Can you please help me out how to make top n selection by using slider.

Thanks,

Deepak

[#2]

Hi Deepak,

Under Slider properties, have a variable maintained and use the same variable in Dimension Limit Tab of Chart properties.

Hope this helps !

Sree

[deepakqlikview_123]

Hi Sreejith,

In Pivot table there is no dimension limit tab.

In this case can u plz tell me how to handle this.

Thanks,

Deepak

[jagan · Accepted solution]

Hi Deepak,

Please find attached file for solution.

Regards,

Jagan.

[VishalWaghole]

Hi Deepak,

aggr(if(Rank(sum(Enquiry))<=variable,DealerName),DealerName)

Create slider and assign variable to slider.

Hope it will work for you.

-- Regards,

Vishal Waghole