AnsweredAssumed Answered

Count of Unique Related Records

Question asked by mmcabee on Nov 30, 2009
Latest reply on Nov 30, 2009 by comment_1

Title

Count of Unique Related Records

Post

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!

 

 

Outcomes