Hello I need to create two buttons, one to open a detail field in the same sheet and one to hide the previous field opened.
Is it possible?
Is your detailed field a dimension of the chart ?
1) create a variable taht will contain 1 or 0
2) your button will do sth like : mod(vHide+1, 2) to switch from 0 to 1. You may also test the variable to modify the test : sth like = if(vHide=1, 'Hide', 'Show') & ' Detail'. You'll get only ONE button instead of two
3) In the chart (or table) in the dimensions tab, choose your Detail Dimension, Enable conditional = vHide
Ok, i intend to use this logic;
But in the button actions which action have i to choose?