This content has been marked as final. Show 5 replies
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.