I have a order list by region (NWOrders, SWOrders, etc.). Is there a way to get distinct record by Customer. For example, Customer Roger Nigel has 70+ orders in the NWOrders library, John Doe has bunch of orders in the SEOrders library. I just need to get distinct customers from each library.
The reason for this is compare all the customers in the various orders library against customerLibrary to see who has not placed any orders so marketing can target those customers.
How do I get unique customers from each library?
0 commentaires:
Enregistrer un commentaire