Hi,
I am looking for a way so that for each transaction month, it should also include the previous 2 months as well, so it is a rolling figure.
e.g.
| Month | Value | 2 Month Value |
|---|
| Jan2013 | 100 | 800 (Jan2013+Dec2012+Nov2012) |
| Dec2012 | 200 | 750 (Dec2012+Nov2012+October2012) |
| Nov2012 | 500 | (Nov2012+Oct2012+Sept2012) |
| Oct2012 | 50 | (Oct2012+Sept2012+Aug2012) |
I would also like to do this for weeks as well.
Thanks in advance
