Slider

[#1]

    Hi all,

I got a pivot table containing the following information:

                                        revenue     revenue ex     %

Divisionname+Week

Now I would like to make slider that selects the number of weeks i want the table to show me. When I slide it to the number 7 it shows me 7 weeks. Do I need to put a variable in my dimension?

Like

                    weeks               revenue     revenue ex               %

Divsion  1      -1

                    -2

                    etc

Division 2       -1

                     -2

                      etc

kind regards

[#2]

In your Slider Properties, under Field, choose Expression, and then type [weeks]

Lucas

[sundarakumar · Accepted solution]

I think u need to define a calculated dimension for week in the pivot table like,

if(weekno<vSlider,weekno,null())

then select the calculated dimension and check suppress null values

create a slider object and variable called vSilder to complete the process..

-Sundar

[#4]

thanks for the quick response!

[sundarakumar]

You are welcome