Year on Year, Month on Month Variance

[#1]

Hi, I need to dispaly Year on Year Variance, Month on Month Variance in my dashboard.

I have the following code for Month:

=sum(if(MEASURE_ID=50,NUMERATOR, if(MEASURE_ID=51,NUMERATOR,

if(MEASURE_ID=54,NUMERATOR, if(MEASURE_ID=56,NUMERATOR, if(MEASURE_ID=55,NUMERATOR,

if(MEASURE_ID=61,NUMERATOR, if(MEASURE_ID=53,NUMERATOR))))))))

and it returns this view:

I have the following code for Year:

=sum({$<Month=>}(if(MEASURE_ID=50,NUMERATOR, if(MEASURE_ID=51,NUMERATOR,

if(MEASURE_ID=54,NUMERATOR, if(MEASURE_ID=56,NUMERATOR, if(MEASURE_ID=55,NUMERATOR,

if(MEASURE_ID=61,NUMERATOR, if(MEASURE_ID=53,NUMERATOR)))))))))

and it returns this view:

I now need to display Year on Year Variance and Month on Month Variance. Please help