Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to take a button and write an expression that gives me the top 3 values in dimension. The parentheses and bar format is not working as I thought it would (I tried to write (max(var)|max(var,2)|max(var,3)). Does anyone have a good way to accomplish this? Thank you.
Hi,
In the Button object, add the Action = "Select values matching search criteria", and in the Value box, put something like this:
='($(=max(var))|$(=max(var,2))|$(=max(var,3)))'
Thank you! This works perfect.