Forum Discussion
Vaibhav002
Nov 17, 2022Copper Contributor
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 a...
- Nov 17, 2022
Vaibhav002
Nov 17, 2022Copper Contributor
Desired output is below
Broker Name>>Count of unique customers served
Broker 1 >1
Broker 2 >1
Broker 3>2
Broker Name>>Count of unique customers served
Broker 1 >1
Broker 2 >1
Broker 3>2
Riny_van_Eekelen
Nov 17, 2022Platinum Contributor
- Vaibhav002Nov 17, 2022Copper ContributorThanks Riny_van_Eekelen..This really helped