YTD Calculation in WEBI

Hello,

I am trying to calculate Year To Date values based on the period values selected by users via input controls.

Say if period 5 is selected, then the YTD measure on the graph must display the total value of the first 5 months.

The data provider is based on a Bex query.

Any suggestions please...

Thank you.