Centered 3 months average (as a column)

• Type: Inserted as a column
• Description: Calculates the average of 3 months' intervals - from 1 month before to 1 month after any month.
• Range:
  • Columns: Last column
  • Rows: 3 rows intervals
  • Measures: First measure
• Syntax:

avg(d-1, -1:1, m1)

• Sample crosstab:

Example

Adding the 3 months rolling average, the table will now look like this:

NOTICE: 
The first month and the last month will not be correct, since it won't include full 3 months in the average. 
If you want to adress this, you can add a visiblity agent, that hides the 3 months rolling average value with this syntax:
count(c1,d1:0,m1)<2 or count(c1,d-1:0,m1)<2

Choose properties, visibility agents

Pick Hide Value

Pick 3 months rolling average

Add the condition shown above:

And your table will now hide the incorrect values: