3 Replies Latest reply on Mar 2, 2012 12:27 PM by Tracy Rodgers

    How do i get a SUM of Distinct values in a column?

    Archana Amarnath

      Hi,

      Below is a sample of my Data Structure:

      SKU IDREGIONSales
      SKU 1Central200
      Midwest200
      Southeast200
      SKU2North Atlantic300
      Central300
      Midwest300
      South West300
      South East300

       

      I need to find a way to sum distinct values only.

       

      Eg: Sales for SKU 1 and SKU 2= 200+ 300;

      Basically, AVG (Sales for SKU 1) + AVG (Sales for SKU 2)