Accumulated sum from the left (as a measure)

  • Type: Inserted as a measure
  • Description: Calculates an accumulated sum of values from first column to each column.
  • Range:
    • Columns: From first column to each column
    • Rows: Each row
    • Measures: First measure
  • Syntax:
sum(d1:0, 0, m1)
  • Sample crosstab:

 

Example

We want to accumulated each row from the left to the right for the first measure (Revenue).

Adding the Accumulated sum from the left (measure) gives this result:

 

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

Comments

0 comments

Please sign in to leave a comment.