Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi community,
unfortunately I have not found any suitable solution to my problem here in the community.
I would like to make a selection in a table (diagram) with a button. The selection should select all records whose value formula (column) is greater than 10.
How can I implement in the best way ?
Am grateful for any help.
Best Regards,
Hi,
declare a variable with value 10. lett's call the variable v_limit.
create a button and on actions tab, select "Set variable" with the name of the variable and set the value with this expression : if($(v_limit)=10,0,10)
By cliking on teh button, the value will be either 10 or 0.
Now modify the expression of your column : if(value>=$(v_limit), value)
and select the "suppress zero-values" in presentation tab of your pivot table.
hope this helps
Gilles
hi community,
can nobody help me with my question ?
Best Regards,
Hi,
declare a variable with value 10. lett's call the variable v_limit.
create a button and on actions tab, select "Set variable" with the name of the variable and set the value with this expression : if($(v_limit)=10,0,10)
By cliking on teh button, the value will be either 10 or 0.
Now modify the expression of your column : if(value>=$(v_limit), value)
and select the "suppress zero-values" in presentation tab of your pivot table.
hope this helps
Gilles
Thank you very much