chart selection using textbox with variable

[#1]

Hi Experts,

I want to choose the charts dynamically based on the text box selection.

for example, i have two pivot tables

Table1 : Employee details

Table2 : Employee bonus

i want to choose these two based on selected text boxes

text box1 : Employee details created with variable vTab1 in Actions

text box2 : Employee bonus created with variable vTab2 in Actions

& i  gave this variables in the Layout -> conditional of corresponding pivot tables

but both the tables appears together as default. not as per the selection.

cant able to find the reason.

Please help to fix this

[Anonymous]

like this?

[settu_periasamy · Accepted solution]

Maybe try this

Uncheck  the "show All sheets and object" in Settings -> Document properties ->  Security

Or

Ctrl + Shift + S

[MarcoARaymundo]

Hi!

You need one variable (Employee details = 1, Employee bonus =2), in the textbox add action  Set Variable ->

=If(vShow = 1, 2, 1).