Skip to Content
0
Former Member
Aug 11, 2016 at 01:03 PM

Select customers who only buy from specific suppliers?

36 Views

Hello,

I am working on a report and one of the requirements is to compare how customers who purchase from supplier "A" only or supplier "B" only are doing compared to those who buy from "A" and "B"

So I need a formula that will return "Supplier "A" only customer" or "Suppler "B" only customer" , or "Shared customer" instead of the actual customer's name in the report

Any suggestions on what the variable formula for this would be?

Many thanks

Adrian