1

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:

Aggregate(
{NULL:[Date].[Month Dates].CURRENTMEMBER},[Measures].[Sales]
)

*[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

 

Cumulative measure.jpg (quick view)

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like1 Follow
  • 1 Likes
  • 3 yrs agoLast active
  • 852Views
  • 1 Following