3 Replies Latest reply: Feb 4, 2012 2:42 PM by Przemysław Wojda RSS

    Complex Aggr

    Przemysław Wojda

      Hi All,

       

      I'm looking for an aggr expression that would sum amounts if sum of these amounts by name, year and month are less than 200 - see below example. Important thing - expression will work in pivot table with only two dimenions: year and month.

       

      Input:

      Name, Year, Month, Product, Amount

      John, 2011, 8, A, 150

      John, 2011, 8, B, 30

      Mary, 2011, 9, C, 160

      Mary, 2011, 10, D, 170

      Mary, 2011, 10, D, 40

       

      Output:

      Year, Month, Sum(Amount)

      2011, 8, 180

      2011, 9, 160

       

       

      Regards,

      Przemek