Loop through filtered items to qulify a count

[kazlik]

I have data similar to the table below and would like to do the following

User selects Brand A,B,D from a filter

I want to display the distinct count of ID's per Brand that is qualified based on the following
ID must have a Competitor type of 2 and also a type of 1 that is in the selected Brands and not all for that ID
In this case I should get the following

A = 2 (ID 1 and 2)
B = 1 (ID 1)
D = 1 (ID 2)

ID 3 would not qualify as brand F is not selected
ID 4 would not quality as brand G is not selected

ID	Brand	Competitor type
1	A	2
1	B	1
1	C	1
2	G	1
2	D	1
2	A	2
3	D	1
3	B	1
3	F	2
4	A	2
4	G	1
5	G	1

[Anonymous]

Hi @kazlik,

   can you please post a sample data table. I didn't understand so much the explanation, and starting with a bunch of data it can be much more simple.

#I'M Not An Expert#

[MattAllington]

I would like to help you, but the explanation is really confusing.  Can you have another go at explaining what you need.