Home > OLAP Calculation Templates > Cumulative Aggregates > Cumulative Total
![]() Previous |
![]() Next |
Calculates a running total across a range of consecutive time periods.
Cumulative total (sum) of measure (...) in the time dimension and time hierarchy within { level | parent | ancestor at level level | }. Total from { beginning to current | current to following | beginning to following } member.
This calculated measure computes the total number of Units from the first time period in the year to the current time period.
Cumulative total (sum) of UNITS (...) in the TIME dimension and TIME.CALENDAR hierarchy within ancestor at level TIME.CALENDAR_YEAR. Total from beginning to current member.
SUM(UNITS_CUBE.UNITS) OVER HIERARCHY (TIME.CALENDAR BETWEEN UNBOUNDED PRECEDING AND CURRENT MEMBER WITHIN ANCESTOR AT LEVEL TIME.CALENDAR_YEAR)
The Total column shows the total number of Units from the first quarter in the year to the current quarter. At the Calendar Year level, 2005 and 2006 are the only periods within their respective ranges.
Time Level Units Total ------ ------------------- -------- ------- Q1.05 CALENDAR_QUARTER 143607 143607 Q2.05 CALENDAR_QUARTER 138096 281703 Q3.05 CALENDAR_QUARTER 138953 420656 Q4.05 CALENDAR_QUARTER 145062 565718 Q1.06 CALENDAR_QUARTER 146819 146819 Q2.06 CALENDAR_QUARTER 145233 292052 Q3.06 CALENDAR_QUARTER 143572 435624 Q4.06 CALENDAR_QUARTER 149305 584929 2005 CALENDAR_YEAR 565718 565718 2006 CALENDAR_YEAR 584929 584929