Hello All,
I am trying to do a year over year calculation based on month to month data which is represented in another cell for a dashboard. I have the YoY calculations working but because that % needs to be represented on a seperate worksheet in a dashboard I can only get the current month %. What I'd like to have it do is compare MoM on a rolling basis. For example when April Month-end gets populated I would like the calculation to look at the April cells without having to change the calculation manually. Is this possible?
Thanks in advance
MTD YTD MTD YTD YoY
Jan-12 1,259,004 1,259 Jan-13 6,959 6,959 -452.76%
Feb-12 7,476,538 8,736 Feb-13 4,443 11,402 -30.52%
Mar-12 4,621,829 13,357 Mar-13 4,411 15,813 -18.38%
Apr-12 4,305,276 17,663
May-12 6,573,996 24,237
Jun-12 7,088,530 31,325
Jul-12 11,946,233 43,271
Aug-12 3,965,033 47,236
Sep-12 5,560,432 52,797
Oct-12 161,582,186 214,379
Nov-2 19,245,328 233,624
Dec-12 17,063,466 250,688
I am trying to do a year over year calculation based on month to month data which is represented in another cell for a dashboard. I have the YoY calculations working but because that % needs to be represented on a seperate worksheet in a dashboard I can only get the current month %. What I'd like to have it do is compare MoM on a rolling basis. For example when April Month-end gets populated I would like the calculation to look at the April cells without having to change the calculation manually. Is this possible?
Thanks in advance
MTD YTD MTD YTD YoY
Jan-12 1,259,004 1,259 Jan-13 6,959 6,959 -452.76%
Feb-12 7,476,538 8,736 Feb-13 4,443 11,402 -30.52%
Mar-12 4,621,829 13,357 Mar-13 4,411 15,813 -18.38%
Apr-12 4,305,276 17,663
May-12 6,573,996 24,237
Jun-12 7,088,530 31,325
Jul-12 11,946,233 43,271
Aug-12 3,965,033 47,236
Sep-12 5,560,432 52,797
Oct-12 161,582,186 214,379
Nov-2 19,245,328 233,624
Dec-12 17,063,466 250,688