5 Replies Latest reply: Oct 31, 2014 10:30 AM by Helen Betty RSS

    Aggregate data for the last 12 months

      Hi All,

       

      I'll appreciate your prompt assistance on an issue I have.

      I have a table which has the following fields:

      Date, Transaction_Type, Amount

       

      I would like to aggregate the last 12 months amount for each Transaction_Type on a monthly basis

      i.e

      for the 31/01/2012 the sum of the amount from 1/2/2011 to 31/01/2012

      for the 28/2/2012 the sum of the amount from 1/3/2011 to 28/2/2012

       

      all of this should be for each Transaction_Type.

       

      Thanks in advance.

      David