Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like build a button who enable or disable a metric in a pivot table.
do you know how to do that?
Example ; Pivot table
Dim1, Dim2, Metric1, Metric2
When the user clic on the button the pivot table structure become:
Dim1, Dim2, Metric1
Ah. Well You could create a new table then and show hide each table based on the button.
Version 11 allows for conditional expressions, which would be easier.
For either the button would have an action for set variable.
you could use an if statment like this to set it:
=if(vFlag=0,1,0)
Then the condition would be:
$(vFlag)=1
Which version are you using?
Version 10
Ah. Well You could create a new table then and show hide each table based on the button.
Version 11 allows for conditional expressions, which would be easier.
For either the button would have an action for set variable.
you could use an if statment like this to set it:
=if(vFlag=0,1,0)
Then the condition would be:
$(vFlag)=1