Salesforce: Report Cumulative Formula

In this short video I will demonstrate how to do a cumulate total in salesforce reporting.

[@PierreKoever]

Thanks you so much for this ! Very helpful for my desire to build MAT's / Rolling Totals / Last-Twelve-Months into Salesforce.

[@ivorthecheeseman]

this is awesome, thanks mate!

[@facundocarreras3267]

Sos un capo hermano, me salvaste. Gracias.

[@PabloGarfunkel]

So, this is great and am putting it to use... except I am hitting a huge snag...
I am trying to do a rolling 12 months sales report... so I just replicated your proposed formula x12. Problem is I have months where there are no data points (no records) and Salesforce, in such case, just omit period in the summary report :-\
So I am ending with not really a last 12 months rolling sales report, but rather last 12 available iterations with records on the period. How would you propose to deal with that gap?

[@aslambagwan6032]

Thanks

[@edwilson9183]

Is it possible to spit out a percentage increase instead of currency?

[@tinaodell7268]

Yes, you will use ----( the cumulative amount formula) / PARENTGROUPVAL(Amount__c:SUM , GRAND_SUMMARY)

[@Chelseaclaire100]

Can you do this for all time? It seems to only let me do up to 12 months?

[@bizlexx]

yes