Nov 17 2022 02:58 AM - edited Nov 17 2022 03:00 AM
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 |
Nov 17 2022 02:59 AM
Nov 17 2022 03:08 AM
SolutionNov 17 2022 03:38 AM
Nov 17 2022 03:08 AM
Solution