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

    Count of Unique Related Records

    mmcabee

      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!