Creating a Cumulative Measure
Creating a cumulative measure in BI Office can be accomplished by creating a custom measure with a very simple MDX code.
In this example, I would like to replace the measure Sales in the bellow grid with a cumulative measure based on Sales called Cumulative Sales:
To create the cumulative measure, I've created a new custom measure with the bellow MDX code:
*[Date].[Month Dates] - Needs to be replaced with the Hierarchy name.
*[Measures].[Sales] - Needs to be replaced with the measure you would like to accumulate
After creating the cumulative measure I've placed it on Rows instead of Sales and here is the result:
Please see attached screenshot for more information