sum over 12 month for each month

[Anonymous]

Hi

I have a chart where for each month I need the cumulative sum of value over previous 12 months prior to that month

for example:

Jan 2016 = SUM({< MONTHS=Feb 2015 - Jan 2016  >} VALUE)

Feb 2016 = SUM({< MONTHS=Mar 2015 - Feb 2016  >} VALUE)

etc...

Thank you in advance for your help

[Anil_Babu_Samineni]

You want to show values while selection?

[Anonymous]

YES

[sunny_talwar]

Here is one approach:

The As-Of Table

Other one is to use RangeSum(Above()) function on the front end

[othniel2014]

Script:

Num([DateField])as NumDate

Graphic:

Sum({1<

NumDate={$(='">= ' & $(=Num(MonthStart(AddMonths(min(Num([DateField])),-11)))) & ' <= ' & $(=floor(num(max([DateField])))) &'"')}

>} [AmountField])

[renuka_sasikumar]

Hi,

Did you got the solution for this.