Forum Discussion
Loop through filtered items to qulify a count
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 |
2 Replies
I would like to help you, but the explanation is really confusing. Can you have another go at explaining what you need.
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#
