Expression in filter pane: Select more than one choice from a dimension

[Anonymous]

Hi,

Is there a way to write an expression in order to create a "fast choice button" on a filter pane?

In the dimension Department, I have three departments (HR, Finance & Legal) that I would want to include in the filter pane as "Business support" in order to save the user two clicks.

I've looked around and found solutions on how to filter out one, or show sub-categories, but nothing on above. I'd be grateful if anyone can help, thanks!

[OmarBenSalem · Accepted solution]

Create a filter as follow:

if(Department='HR' or Department='Finance' or Department='Legal', 'MyGroup', 'other')

per analogy; u can even use it as a button not a filter

as follow:

create a treemap

as dimension:

=if(Dep='Dep1' or Dep='Dep2','MyGroup','Others')

as a measure : 1

result:

[Anonymous]

Perfect! Thank you!