Forum Discussion
Solved
Require unique count in pivot or using formula
Hi all,
Need a quick help in figuring out the count of unique customers served by a broker.The data I have is across category and hence its possible that one broker is serving the same customer across multiple categories and hence the count in pivot is not unique.I am attaching a sample input and output data.Please suggest how can this be achieved.Thanks!
INPUT:
| Broker Name | Customer Name | Category |
| Broker 1 | Customer 1 | Category 1 |
| Broker 1 | Customer 1 | Category 2 |
| Broker 1 | Customer 1 | Category 3 |
| Broker 1 | Customer 1 | Category 4 |
| Broker 2 | Customer 2 | Category 1 |
| Broker 3 | Customer 1 | Category 1 |
| Broker 3 | Customer 3 | Category 2 |
Desired OUTPUT using formula or pivot
| Broker Name | Count of unique customer serviced |
| Broker 1 | 1 |
| Broker 2 | 1 |
| Broker 3 | 2 |
- Desired output is below
Broker Name>>Count of unique customers served
Broker 1 >1
Broker 2 >1
Broker 3>2- Thanks Riny_van_Eekelen..This really helped
