AnsweredAssumed Answered

Count of Unique Related Records

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


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!