Calculating the rolling 12 months sum and displaying it from the middle of the months
i have the data as below
I have to show in the pivot table the past cumulative 12 months sum of disengagemnets where months are transposed. For EX: For july it is same as 10.
For Aug,it should be sum of Aug and July(10+9).
this is am able to get using the below expression if i display the data from July 2014
rangesum(BEFORE ( sum( MnthlyDisEngCount),0,12)).
Here the record is starting from July 2014 so we have no problem in writing the above expression.
But the requirement is i want to show this data only from the Year 2014 only. When i am filtering this data for the month of year=2014 in the dimension itself,i am not getting the desired result. But from the month of Jan 2014,it should give the summation of past 12 months data . Can any one help me on this.