Accumulated average (as a measure)

  • Type: Inserted as a measure
  • Description: Calculates the accumulated average from the first row value to the current row value, in the range.
  • Range:
    • Columns: Each column
    • Rows: From first row to each row
    • Measures: First measure
  • Syntax:
avg(0, d1:0, m1)
  • Sample crosstab:

 

Example

By adding the accumulated average as a measure, the table now looks like this:

 

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.