It is recommended to get familiar with cumulateFromDate function before proceeding with this tutorial.

The result of this tutorial will be a table with cumulated value of an indicator (eg. payments) for each year and each month of the year.

Table settings

To be able to display cumulated values by month for each year, you need to add two date drill-downs, one on horizontal header (drill-down by month of year) and second one on vertical header (drill-down by year).

Formula indicator

cumulateFromDate(contextYear()) {M_INVOICED_QUANTITY }

Result

Sample BellaApp

Click here to download BellaApp with sample report.