So it's a challenge ! But it's a good notice that Accumulation is not taking the previous amounts into consideration if the present row segment has a zero/null value.
See the solution (as you said that Pivot is right) attached.
Thats the same as what I came up with tresco but I could get 12 for March but the graph was still not showing all 3 types it is frustrating and there must be a way to do it! i refuse to be beaten hehe
But it's a good notice that Accumulation is not taking the previous amounts into consideration if the present row segment has a zero/null value.
