YTD , year over year

[#1]

PLZ find the attachment

HELPful  for ytd ever

[MK_QSL]

=SUM({<Date = {">=$(=Date(MakeDate(max(Year),1,1),'DD MMM YYYY'))<=$(=Date(MakeDate(Max(Year),Month(Today()),Day(Today())),'DD MMM YYYY'))"}>}Value)

[#3]

Hi

PFA the QWV.

Hope this is helpful.

Thanks

Sabal

[#4]

Hi, thank u for post this is cytd

but privous ytd How?

[#5]

Hi, saxena in 2nd chart , if i selected 2013 then it shows july 2012 to dec 2013 plz check

[#6]

Hi

What is the requirement if you select 2013?

Thanks

Sabal

[#7]

Hi

if i select 2013 or any year

jan 01 2013 to jul23 2013 (ytd)

jan 01 2012 to jul23 2012(pytd)

[#8 · Accepted solution]

Hi

PFA the updated sheet.

Let me know if this is what you were looking for.

Thanks

Sabal

[#9]

THANX  A LOT

SAXENA

MY doubts clear on ytd