Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Like Attached?
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.
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
Like Attached?
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?
Sorted it now, I amended it to the following:
=' Show ' &if(vShowMultiple = 1, 'Dimensions',
if(vShowMultiple = 2, 'Filters','Measures'))