MDX rolling measure

• 8reat1s

  SSChasing Mays

  Points: 616

  More actions

  May 29, 2013 at 9:27 pm

  #273338

  hi,

  I am trying to achieve a rolling measure in my cube which is populating a measure based upon the below data

  status_id event_datetype_id

  17 2011-01-10 2

  33 2011-01-12 2

  14 2011-01-13 2

  12 2011-01-15 2

  6 2011-01-22 2

  Currently I am using a calculated member

  Sum(NULL:[Event Date].[Date].Currentmember * [status].[Status ID] * [type].[Type ID],[Measures].[status id cnt])

  Which brings data like this

  10/01/201211/01/201212/01/201213/01/201214/01/201215/01/2012

  171 1 1 1 1 1

  33 1 1 1 1

  14 1 1 1

  12 1

  My desired result is

  10/01/201211/01/201212/01/201213/01/201214/01/201215/01/2012

  171 1

  33 1

  14 1 1

  12 1

  I feel I am pretty close

  Can you please help me achieve my desired result?