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