1 Reply Latest reply on Nov 30, 2009 9:06 AM by comment_1

    Count of Unique Related Records



      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!