Pivot table and button

[#1]

   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

[#2]

Which version are you using?

[#3]

Version 10

[#4 · Accepted solution]

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