Want YTD on selected date

[#1]

Hello,

           i want YTD to be calculated on Selected date by user.

for example if user select date 15 feb 2009

user should get sales of from 1 jan 2009 to 15 feb 2009

how to do it?

thanks

Harlin

[#2]

See that there is not control of the year...

Stefano

[#3 · Accepted solution]

Hello

finally this worked

=Sum({$<Year = {$(=max(Year))}, Month={"<=$(=max({<Year={$(=max(Year))}>} Month))"},OrderDay={"<=$(=max(OrderDay))"}>} Value)

thanks Stefano for the response

my date is formated in M/D/YYY format.

thanks

Harleen Singh