What is difference between YTD, PYTD and YOY,

[madhubabu]

Hi QV Experts,

Can any one help me with what is YTD, PYTD and why we use this. How to write those expressions in front end and in back end.

Also I went to what is the difference between YOY and YTD.

What exactly mean by YOY and YTD. Can any one tell me the expressions for that.

thanks,

M@dhu

[#2 · Accepted solution]

May be you can try as below three expression with 2014-2013, 2013-2012, 2012-2011 as labels accordingly for below expression:

=((sum({$<Year = {$(=max(Year))}>}Sales) - sum({$<Year ={$(=max(Year)-1)}>}Sales))/ sum({$<Year = {$(=max(Year)-1)}>}Sales)) * 100

=((sum({$<Year = {$(=max(Year)-1)}>}Sales) - sum({$<Year ={$(=max(Year)-2)}>}Sales))/ sum({$<Year = {$(=max(Year)-2)}>}Sales)) * 100

=((sum({$<Year = {$(=max(Year)-2)}>}Sales) - sum({$<Year ={$(=max(Year)-3)}>}Sales))/ sum({$<Year = {$(=max(Year)-3)}>}Sales)) * 100

[madhubabu]

Hi Habib Shaik,

Thank you so much.

With Regards,

M@dhu