Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Maybe try this
Uncheck the "show All sheets and object" in Settings -> Document properties -> Security
Or
Ctrl + Shift + S
like this?
Maybe try this
Uncheck the "show All sheets and object" in Settings -> Document properties -> Security
Or
Ctrl + Shift + S
Hi!
You need one variable (Employee details = 1, Employee bonus =2), in the textbox add action Set Variable ->
=If(vShow = 1, 2, 1).