Forum Discussion
YearToDate transfornation into Monthly data
Hi all, Short probably simple question. The data looks as following: Date Customer Volume Cost Jan-22 X 1 11 Feb-22 X 2 12 Mar-22 X 3 13 Jan-22 X 4 14 Jan-22 X 5 ...
For customer Z for Jan the Volume should be 0+1, cost 10+11, cost/vol = 21
For customer Z for Feb YTD the Volume should be 8+2+3+5, cost 18+12+13+15, cost/vol= 3.22
My goal is to calculate for each customer Vol Feb (18)-Jan (1) = 17, Cost Feb (58)-Jan (21)= 37, then the Feb cost/col= 2.18
The data is random but mathematically it doesn't matter.
maati