I have the following table:

DATE                  SALE AMOUNT

1 Jan 2009            15

1 Jan 2009             5

2 Jan 2009            15

3 Jan 2009            15

...

1 Jan 2010            25

1 Jan 2010            5

...

Each sale adds a new row with the date of the sale and the amount. I need to compare March 2012 to March 2011 but cumulative. For example today March 15 2012 I need to see:

From 1st of March 2011 to 15th of march 2011 TOTAL 

VS.

From 1st of March 2012 to 15th of March 2012 TOTAL

This to understand how the month is looking compared to previous year without having to wait end of month to compare the two totals.

I believe CUMULATIVE totals are not possible in Zoho, but pls advise a way around.. I tried with pivots but could not figure it out.. maybe a new query table with an additional IF column to only select days where 2011 and 2012 data is available?

Thanks!