Cumulative YTD month by month

[bm59]

Hi,

I would build a chart with each month display cumulative YTD.

My data look like:

Date      | Store  | Sales

2010/01    Paris     105

2010/02    Paris     100

2010/03    Paris     108

....

2010/11    Paris     167

2010/12    Paris     1898

2011/01    Paris     195

2011/02    Paris     1066

2011/03    Paris     1078

....

The final graph must look like; Cumulative 12 months each month

         | Fev10 To Mar11    |    Mar10 To Avr11   |   Avr10 To May11   |    May10 To Jun11   | ...

Paris  | 

...       |

Thx for your help.

[#2]

Hi,

  As seen in the sheet of the attached application, in the pivot table, we need cumulative sales amount.

The before() function works fine till second month, then later gives wrong results.

Please check and suggest an appropriate solution.

Thanks and Regards,

-Karthik G

PS I have demonstrated with the test application posted above. Thanks.

[#3]

Hi,

Any appropriate solution?

Thanks and Regards,

-Karthik

[johnw]

I think this?

rangesum(before("Sales cumm"),SalesAmt)