1. TARGIT Community
  2. Documentation
  3. Frontend: Designer, Consumer
  4. Calculations
  5. Predefined Calculations

Accumulated sum from the top (as a measure)

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

 

Example

We want to accumulate Revenue in all the years in one go.

This is done by adding Accumulated sum from the top (measure)

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

Comments

0 comments

Please sign in to leave a comment.

Articles in this section

See more