Hello,
My data is setup in this way:
Date | Day | Area | Product | SalesmanName |
01/07/2021 | Thu | A1 | Prod-1XN | Salesman1 |
01/07/2021 | Thu | A1 | Prod-1XN | Salesman1 |
01/07/2021 | Thu | A1 | Prod-1XN | Salesman1 |
01/07/2021 | Thu | A1 | Prod-1XN | Salesman1 |
01/07/2021 | Thu | A1 | Prod-1XN | Salesman1 |
01/07/2021 | Thu | A2 | Prod-1XN | Salesman1 |
01/07/2021 | Thu | A2 | Prod-1XN | Salesman1 |
01/07/2021 | Thu | A2 | Prod-1XN | Salesman1 |
02/07/2021 | Thu | A1 | Prod-1XN | Salesman1 |
02/07/2021 | Thu | A1 | Prod-1XN | Salesman1 |
02/07/2021 | Thu | A1 | Prod-1XN | Salesman1 |
02/07/2021 | Thu | A1 | Prod-1XN | Salesman1 |
02/07/2021 | Thu | A1 | Prod-1XN | Salesman1 |
02/07/2021 | Thu | A2 | Prod-1XN | Salesman1 |
02/07/2021 | Thu | A2 | Prod-1XN | Salesman1 |
02/07/2021 | Thu | A2 | Prod-1XN | Salesman1 |
The Cell F2 has Salesman name and in G2, I need a formula, which will count the salesman visits in areas on all dates.
So in this case, the formula should return 4 (on 1st July, he visited 2 areas, on 2nd July, he visited 2 areas).
The pivot tables are counting salesman's name and giving me count of 16, which is not the right answer.
Highly appreciate your help.
Many thanks