Filtering data with 2 columns with beast mode?

KeiNish

Now I have a dataset something as below;

ID	Cat	Name	Cond01
0001	1	A	3
0002	2	B	4
0002	1	A	3
0001	1	D	1
0003	2	B	7
0003	1	C	5
0004	1	A	9
…	…	…	…

Now I want to make two filter cards to select data by Name , conditioned with a Cat value,

where one card is for filtering data by Name when Cat = 1,

another one by Name when Cat = 2.

I want to extract data, for example, Name=A When Cat = 1 with the former and Name=B When Cat = 2 with the latter to get as below;

ID	Cat	Name	Cond01
0001	1	A	3
0002	2	B	4
0003	2	B	7
0004	1	A	9

But they don't work, they work separately.

Does anyone have an good idea to filter data with filter cards as above?

Thanks in advance!

ColemenWilson

Because you want to see the two combinations simultaneously, you'll need to combine the two columns. I did this using CONCAT(). I don't think this is the perfect solution, but it works. If you have many combinations of Cat and Name then this may not be ideal.

1. Create a beastmode: CONCAT('Cat = ',Cat,' & Name = ',Name)
2. Make the above beastmode a filter on the table card
3. Make the selections in the filter:
   

4. End result is what you're looking for:

ColemenWilson

Because you want to see the two combinations simultaneously, you'll need to combine the two columns. I did this using CONCAT(). I don't think this is the perfect solution, but it works. If you have many combinations of Cat and Name then this may not be ideal.

1. Create a beastmode: CONCAT('Cat = ',Cat,' & Name = ',Name)
2. Make the above beastmode a filter on the table card
3. Make the selections in the filter:
   

4. End result is what you're looking for:

KeiNish

Thanks, ColemenWilson. It worked for tables to me.

But indeed, what I really want is to make two or more filter cards function separately to get the data.

For example, filter card X contains Name values A and C, and Filter card Y contains B and D.

But choosing B of filter card Y after choosing A of filter card X, the choice of A is cancelled.