calculate sales for last 60 days

[Former Member]

hello

want to make key figure or formula, which calculate sales for last 60 days, but also i need to add week group in report, so for each week i need sum sales for last 60 days before this ...

is any solution to that?

thank you.

[Former Member]

Following are steps --

1. Create a dummy formula variable for accepting user input for Calweek

2. create restricted KF. Restrict Sales by calday.

restict calday by a variable ( customer exit, interval)

3. set off-set of -60 for low as well as high range

4. in customer exit populate calday var low range with first day of week & high range with last day of the week which is inputted by user.

[Former Member]

Alex,

I'm not very clear on what you are asking.

If you use your time parameters in selections you can use caldays and weeks with your key figures.

ie. Selection 1 has your key figure and calday restricted t the last 60 days.

Selection 2 has your key figure and Fiscal Week but I am not clear on the range required for fiscal week.

Regards

Gill