I am in the process of planning a complex report. This report calculates Division, District, and Store leve information. One of the requirements it to make it expandable. This report should calculate past 3 periods last weeks numbers for sales, inventory, and payments. Another requirements it this report should show all the weeks data for current peirod and it shoudl calculates % change from previous years same priod and week. I am not sure how to get these calculations done (same period last year and same week%)
I also would like to find out how can I assemble this report so I can organize information however I seem it fit. Any help of suggesion will be greatly appriciated.

This message has been edited. Last edited by: Kerry,

Arif,
I will write it for you for a fee.
Then you can see how it is done.
Greg

Here is a suggestion.

Create an aggregate summary table on a weekly basis with weekly sales,inventory & payments info.

DEFINE FILE BLAH
*****Get Current week Date:
TODAY/YYMD = &YYMD;
DAY_NUM/D = TODAY;

CURRENT_START_WEEK/YYMD = DATEADD(DATEMOV(TODAY,'BOW'),'D',-7);
CURRENT_END_WEEK/YYMD = DATEADD(DATEMOV(TODAY,'EOW'),'D',-7);

****** GET SAME WEEK LAST YEAR
PREV_YR_START_WEEK /YYMD = DATEADD(DATEMOV(CURRENT_START_WEEK,'BOW'),'Y',-1);

PREV_START_WEEK/YYMD = DATEMOV(PREV_YR_START_WEEK,'BOW');

PREV_YR_END_WEEK /YYMD = DATEADD(DATEMOV(CURRENT_END_WEEK,'EOW'),'Y',-1);

PREV_END_WEEK/YYMD = DATEMOV(PREV_YR_END_WEEK ,'EOW');

******WEEKLY SALES INFO
CURRENT_WEEK_SALES/D15.2C = IF WEEK GE CURRENT_START_WEEK AND WEEK LE CURRENT_END_WEEK
THEN SALES ELSE 0;

PREV_YR_WEEK_SALES/D15.2C = IF WEEK GE PREV_START_WEEK AND WEEK LE PREV_END_WEEK
THEN SALES ELSE 0;
END

TABLE FILE BLAH
SUM
PREV_YR_WEEK_SALES
CURRENT_WEEK_SALES
**COMPUTE CALCULATION FOR YOY%

BY DIVISION
BY DISTRICT
BY STORE
END

Hope this helps you get started

Cheers

This message has been edited. Last edited by: WFLurker,

Sounds like some training and/or consulting is in order.