How do I calculate Year to Date?

Dear Colleagues,

I need to calculate Year to Date-revenue. Date is a prompt input, so the customer can choose which ever day he wants. How can I get revenue YTD based on the input? Is this a BODI assigment more than a BO assignment?

Looking forward to give you some points!

Regards Silje