Trailing 12 months average (as a column)

• Type: Inserted as a column
• Description: Calculates the average of 12 months' intervals - from any month (included) and 11 months back in time.
• Range:
  • Columns: Last column
  • Rows: 12 rows intervals
  • Measures: First measure
• Syntax:

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

• Sample crosstab:

Example

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

NOTICE: 
The first 11 months the 12 months rolling average will not be correct, since it won't include full 12 months. 
If you want to adress this, you can add a visiblity agent, that hides the 12 months rolling average value with this syntax:
count(c1,d1:0,m1)<12

Choose properties, visibility agents

Pick Hide Value

Pick the 12 months rolling average

Add the syntax shown as condition

This will hide the first 11 values in the 12 months rolling aveage.

Now the table will look like this: