Moving YTD which overlaps to other year?

[Loed]

Hi,

Just wanted to ask if this is possible in query designer?

Basicaly, I have a query which the user can enter the YEARS they wanted in the report. With this, I wanted to create a YTD formula based on the calculation below.

CALCULATION tab in query designer cannot be applied since I am going to use the result of SALES MOVING YTD to another formula.

I tried the REPLACEMENT PATH by CURRENT MEMBER but it only works if user is allowed to enter only a SINGLE YEAR since I can just use a filter JANUARY OF THE YEAR SELECTED IN THE PROMPT up to CURRENT MEMBER.

What if user enters 2 YEARS or more? Do you have an idea how to design this kind of report?

Thank you.

Loed