Year on Year Change

n1ef5ng1 — Mon, 03 Jun 2013 03:24:37 GMT

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

Re: Year on Year Change

Mon, 03 Jun 2013 03:58:23 GMT

Hi,

Could you attach some sample of data and qvw files.

Regards,

Janzen