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 count created issues for rows cumulatively.
-- 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 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 %.