How to apply a complex filter

[Rafael_Curiel]

I need to filter a table based on a specific condition:

My table has three columns: index, description, and responsible.

I need to create a filter with these options:

Responsibles:

Person A

Person 1

Person 2

Person B

Person 3

Person 4

The application of the filter must be like this: when I select the number person, my table shows its correspondent values, but when I select the letter person, the table shows the values from the grouped persons. For example, I selected Person A, and the table shows values from Person 1 and 2; if Person B is selected, the table shows values from Person 3 and 4, but if I select Person 1, the table shows only results from Person 1.

[Rafael_Curiel]

That worked for me, thank you.

[Shaurya · Accepted solution]

Hi @Rafael_Curiel,

Why don't you create the column Responsible with number person values and then add one more column which has value Person A if Responsible is Person 1 or Person 2 and value Person B if Responsible is Person 3 or Person 4.

Then add two slicers, one using the responsible field and the other using the new column that is created. Make both the slicers single select. That way when you select something in the first slicer you will only see one number person and when you select in slicer two you will see two number person.

Did I answer your question? Mark this post as a solution if I did!
Consider taking a look at my blog: Forecast Period - Previous Forecasts