Toggle Button Multiple Choices

[ivandrago]

Hi,

I have the attached Document, at the moment when you click the Button it will switch between dimensions and measures. I want it also to incorporate "Show Filters", so after the measure I want it to only show the Multi Box only and then when the Button is clicked again it will go back to Dimensions and will only show that, hope that makes sense.

Thanks

[richard_chilvers]

At the moment, your variable toggles between 2 values.

You need to change your Actions so it loops round 3 values, for example D (dimensions), M (measures), F (filters).

The conditional show in your object will need to use the relevant value in this variable.

eg. vShowMultiple = 'M' for the measures.

[ivandrago]

So how would this be achievable  using my current logic, not sure what to change using the current actions, would it have to be mutiple IF statements

[sasiparupudi1 · Accepted solution]

Like Attached?

[ivandrago]

Thanks Sasidhar, Yes this is what I am after, but how to I get the correct Description to show on the Button for the next Object it shows next?

[ivandrago]

Sorted it now, I amended it to the following:

=' Show '  &if(vShowMultiple = 1, 'Dimensions',

if(vShowMultiple = 2, 'Filters','Measures'))