Displaying data based on slider

[#1]

I had a slider based on days.(eg: 30,60....).

I have 'Days' column in pivot table.Based on the selection of slider, data should be changed accordingly. But it is not showing.

Eg:       Suppose if I select 30 days in slider, data till 30 days should be shown.If  I select 60 data till 60 days should be shown.

I created a variable on days for slider.

Can anyone reply soon.

[#2]

Hi,

     For this you have to put condition according to your variable which you created for slider  in pivot table expression tab. I think you want to get record for latest 30 or 60 days. So using set analysis, put condition in expression according to variable value.

For better clarification, attach  sample file here.

Regards,

Ashutosh

[bbi_mba_76]

Hi,

you have to change the expressions in your tables to filter data using the variable set with the slider.

[#4]

Hi Sahithya

This can be done quite easily - at least once you know how to write the formula.  Can you send me the name of your variable and the formula you are using and I'll try to amend it to ensure it works?

Regards

Steve

[#5]

Got the solution by creating 2 variables,rangestart and rangeend of slider.

Thanks for all your replies.