Rolling 12 in all periods Chart

[#1]

I have a line chart with year quarter as a dimension and I want to show rolling 12 in each quarter.

If I use aggr and rangesum the last quarter will be right.

How can I do this?

I don´t have the as of calendar.

Regards

Jenny

[Gysbert_Wassenaar]

If you use quarter-year as dimension you'll need an asof table. See this document: Calculating rolling n-period totals, averages or other aggregations