Hi,
I am working on a report where I need to YTD and MTD figure for current and previous year:-
I have followed following steps for current year MTD and YTD figures:-
Create 3 Date variables for Sales on Date with manual input, MTD and YTD on Date characetristics with Customer Exit input. After that I created 3 RKF where I restricted Sales value by each of these date variables.
Now my question is, Do I need to create two more variables for Prior year MTD and YTD figures with customer exit and then create two more RKF's wherein I will restrict Sales figure with respective variable.
Is that correct?
Regards