Hi All,

I have a requirement where I need to display the report right from the beginning of the year till the current week or the user entered week.

Data is displayed by months for all the previous weeks, and only for current month, it should be split in weeks on the report.

For the current week entered(in case this is week 2 of that month), User also wants to see monthly total for that row.
In my report for eg: I am displaying data right from January till August week 2 and also Quarterly sum just after every quarter, YTD in the end. Data is displayed from Jan till July and then for August week1 & week2.
Now I also need August sum(subtotal only for the weeks) and need to pull that as monthly total till date. After this subtotal current quarter & YTD rows needs to be displayed.

Hope the requirement is clear, I am unable to pull a subtotal row only for weeks data. Let me know If there is a way to do this without creating a separate report and appending it.

As the entire logic already put in place, I didnt want to distort the report only for one subtotal row.

Your quick answer really helps!!!

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

Your requirements confuse me, but have you looked into the WHEN expression of the SUBTOTAL command?

quote:

WHEN expression: Specifies the conditional display of subtotals as determined by a Boolean expression.

I am unable to paste the screen shot here.
But report looks like this.

Feb ...............
March...............
April.............
"
"
Aug wk1
Aug wk2
Subtotaling row here is necessary for month..
QTD
YTD

Cannot pull Month data, as we need only 2 weeks data only to be added and displayed.

How is your data available ? On daily basis?
If so you can create a subtotal field based on that field.

Suppose that field is DBDATUM format YYMD .

-SET &MINUS14=&YYMD-14;
DEFINE FILE XXXX
BREAK/YYMD=IF DBDATUM GE '&MINUS14' DATEMOV(DBDATUM,'BOW') ELSE DATEMOV(DBDATUM ,'BOM');
END

TABLE FILE XXXX
SUM AMOUNT
BY BREAK
END

I am sure this is not giving you all what you need, but it is a start to think.
Based on this idea you can create an extra sortcode like 'W' or 'M' you can use to create subtotals.
It is also possible to create a quarter total at the same idea and if you know how to use mcguyver you can combine that technique to this to create exactly the report you need.

Finally you also may look at FML.

Good luck

Thnaks for the suggestions, I was able to solve this by using WHEN condition in Subtotalling.