Skip to Content
0
Former Member
Jun 04, 2009 at 08:51 PM

Prior Year YTD and MTD Sales Figure

51 Views

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