input box and pivot table

[stonecold111]

i have an input box with variable 'vperiod'  predefined values to drop down  ytd;qtd

and whenever input box is changed to 'qtd'  from input box

pivot table is changing accordingly and getting results

can someone explain how pivot table giving results based on selections in input box

[marcus_sommer]

Take a look within the pivot-expression - there will be this variable included - it could be also that this variable is included into anther variable. This meant you need to check all variables.

- Marcus

[Sergey_Shuklin]

Hello, Suresh!

If your pivot table has this expression: sum({<period={"$(vperiod)"}>}sales) it will show result depend on variable value.

[stonecold111]

but it is not used in expression

or other variables

just in layout tab . conditional expression

[marcus_sommer · Accepted solution]

This meant there are several different objects with different expressions and their visibility is controlled through this variable. I think I would rather not use this kind of usability and putting this visibility-conditions in a single object (each expression could be controlled in the same way) or I would use a container for the different objects but if your solution worked you don't need to change it (and now you know what happens and could adjust it if necessary).

- Marcus

[Sergey_Shuklin]

As far as I know Layout tab is containing only condition to show/hide object. You want pivot table to appear during variable changes?

[stonecold111]

yes you both are right..

but i cannot mark as both correct answer. so for the first one

Thanks a lot. serj_shu  marcus_sommer