I have 3 values of a calculated field. When the user click on High, Low, Medium the user doesn't want to see two values from another sheet. But when the user doesn't click on anything (esc on action filter), they want to see the two values.
How to apply extra filters when they click on action filter, but when they don't click on anything, they don't to apply the filter.
Is there is a way to capture action filter action, how to do the above task?
Thanks,
Afroze
7 answers
In the attached I added [Category] to the list of dimensions getting passed in the filter.
For the record, I clicked "show all values" under "Clearing the selection will" in the action definition.
