Showing results for 
Search instead for 
Did you mean: 

Prior Year YTD and MTD Sales Figure

Former Member
0 Kudos


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?


View Entire Topic
Active Contributor
0 Kudos


you can eighter use the -365 preset but i suggest creating 2 seerate variables to avoid problems.