Rolling 12 Month Sum/Average

[#1]

Hi All,

I have a line chart, dimension of month/year with, expression is a sum.  The dataset contains 24 months of data, but I'm only displaying months 13 to 24 on the chart.

I'm trying to add an additional line on the chart that shows a 'rolling 12 month' sum.  So the point at month 24 should show the sum of months 13 to 24, the point at month 23 should show the sum of months 12 to 23 etc.  I'd like to do the same for an average calculation.

Does any one have any suggestions?

Thanks in advance

Tom

[Gysbert_Wassenaar]

See this document: Calculating rolling n-period totals, averages or other aggregations

And these blog posts:

Accumulations‌

The As-Of Table

[ecolomer]

See this: