Selection with buttons

[#1]

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,

[#2]

hi community,

can nobody help me with my question ?

Best Regards,

[#3 · Accepted solution]

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

[#4]

Thank you very much