Conditionally Hide and Show multiple Buttons and Charts

[Rajesh]

Hi All,

I have Buttons like 1,2

when i select 1 it should show A,B Buttons, When i select 2 it should show C Button

after that if i select A then it should show one Pivot table, if i select B then it should show different Pivot table and if i select C then it should show another pivot table.

Can any one please suggest.

Thanks

Rajesh.

[Anonymous]

use variables

in buttons : Action set variable e.g. vButton = 1 or  vButton='Button1'

in other Buttons and Pivot table: Show condition: if vButton=1 or vButton='Button1'

you Need several variables or one variable with different states

[Kushal_Chawda]

Create variable vShow

For button 1 ->

Go to button properties ->Action -> Add -> External-> Set variable

Variable: vShow

Value: =1

For button 2 ->

Go to button properties ->Action -> Add -> External-> Set variable

Variable: vShow

Value: =2

For button A ->

Go to button properties ->Action -> Add -> External-> Set variable

Variable: vShow

Value: =3

Go to button A properties ->Layout -> Conditional ,put below expression

=vShow=1

For button B ->

Go to button properties ->Action -> Add -> External-> Set variable

Variable: vShow

Value: =4

Go to button A properties ->Layout -> Conditional ,put below expression

=vShow=1

For button C ->

Go to button properties ->Action -> Add -> External-> Set variable

Variable: vShow

Value: =5

Go to button A properties ->Layout -> Conditional ,put below expression

=vShow=2

Pivot table for button A ->

Go to Pivot table properties ->Layout -> Conditional ,put below expression

=vShow=3

Pivot table for button B ->

Go to Pivot table properties ->Layout -> Conditional ,put below expression

=vShow=4

Pivot table for button C ->

Go to Pivot table properties ->Layout -> Conditional ,put below expression

=vShow=5

[Rajesh]

Thank you for your reply Kushal,

As u said i created vShow variable and Actions for both 1, 2 buttons

done the same with A ,B buttons

but when i select A button its hiding, I dont want to hide A,B button.

after selecting A button it should dispaly Pivot table_1, in same way after selecting B button it shoud dispaly Pivot table_2.

When i select button 2  A,B buttons should Hide and C button should show

then after selecting C button respected other Pivot table should show.

Plz suggest.

Regards

Rajesh