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?