Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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