4 Replies Latest reply: May 22, 2012 11:27 AM by Phil Bishop RSS

    AGGR Function - set analysis

      Hi all

       

      I have a table with many columns:

       

      Col1 = Has date values (With duplicates)

      Col2 = Has different values for every different date (The same value is on the same date)

      Col3 = Has Product1,Product2,Product3,Product4 (Only these products exists)

       

      is it possible to sum the values in Col2 but only selecting distinct dates.

       

      This mus be done in SET Analysis or the expressions

       

      Kind regards

       

      Martin