Accumulated sum from the top (as a column)

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

 

Example

In the table above we want to accumulate the Revenue for the last year.

We do that by adding Accumulated sum of last column, first measure

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

Comments

0 comments

Please sign in to leave a comment.