CumulativeSum
EAZYBI Calculates the sum of visible row values cumulatively.
This function uses report visible members only and will not return expected results when drilling into details . We recommend disabling drill actions with special annotations comments.
Syntax
CumulativeSum(Numeric_Expression)
Arguments
Numeric_Expression | MDX expression that returns a number |
|---|
Examples
The following formula will cumulatively count created issues for rows.
-- annotations.disable_drill=true CumulativeSum([Measures].[Issues created])
The following formula calculates the % of resolved issues cumulatively.
-- annotations.disable_drill=true CumulativeSum([Measures].[Issues resolved %])
See the report example Lead time distribution in our demo account. The measure Cumulative issues resolved % uses this formula added via default calculations: Add calculated > cumulative sum > including empty for measure Issues resolved %.
See also