Hi Everyone
I have a pivot, and I am working out months rolling. All works fine when I work out 3months, 6months and 12 months rolling, but when I try to work out 9months rolling I get no Values back at all. Does anyone maybe know why this is happening??
This is the expression I am using =sum(if(Inmonths (3,Time, SetDateYear (LatestMonth, max (total Year (Time))), 0,2), Value)) ...
Kind Regards
And thanks in Advance
