Year on Year Change

[n1ef5ng1]

Hi,

I have an isue regarding this table, by logic for % YOY Change, it means comparing the two value of current Jan 12 with previous Jan 11.

I am using pivot table and Month_Year is my Dimension

This is my code to retrieve the value of a particular month    

=if( MonthEnd ( MAX( Date ) ) <> var_EndDate AND MonthEnd( MAX ( Date ) )
= MonthEnd( var_EndDate ) ,

Sum({<
Class_Name = {'La'}
,Status = {'SHIP'}
,Loading = {'ID*'}
>} TEU / Day( var_EndDate )) * Day(MonthEnd(MAX ( Date ))) ,

Sum({<
Class_Name = {'La'}
,Status = {'SHIP'}
,Loading = {'ID*'}
>} TEU))

Any ideas how can I derive the % YOY Change, thank you.

FYI the if statement is to extrapolate the value if is the current month

[#2]

Hi,

Could you attach some sample of data and qvw files.

Regards,

Janzen