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

    Aggregate data for the last 12 months

    David Zenesh

      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


      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.