Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You want to show values while selection?
YES
Script: |
Num([DateField])as NumDate
Graphic:
Sum({1<
NumDate={$(='">= ' & $(=Num(MonthStart(AddMonths(min(Num([DateField])),-11)))) & ' <= ' & $(=floor(num(max([DateField])))) &'"')} |
>} [AmountField])
Hi,
Did you got the solution for this.