Count of Unique Related Records
Struggling to find an elegant way to count the number of unique related records.
The goal is a report that lists for each item sold:
Number of items sold
Total Selling Price
Number of People who bought
Each line item has the itemID, purchase price and customerID. The customerID links to a related Customer database.
I can run a script to mark the individual line item records for unique combinations of ItemID and customerID, but would prefer something more dynamic.
Thanks for any suggestions!