Hello, everyone!

I neeed to create summary report for students by 4 regions. 3 regions has to be by city and student and last one only summary line. Also I asked to do subtotals by region and total for first 3 region and total for all of them.

SUM
STUDENT
compute fields
BY REGION NOPRINT RECOMPUTE MULTILINES AS 'Total for '
BY CITY
BY STDNT_NUM

What I have to code to supress students lines for region EQ '04' and get total for regions '01' '02' '03'?

Something like:



SUM
STUDENT
compute fields
BY REGION NOPRINT
BY CITY
BY STDNT_NUM
ON REGION RECOMPUTE MULTILINES AS 'Total for '
WHEN REGION NE '04'
END

This message has been edited. Last edited by: <Mabel>,

Yes, I tried this but I have no total for Region 04, and it not helps with total for first 3 regions

If I understand you correctly, you want to sort by region and city only if region in not 4 and you want just a total for region 4. Would something like this work?

DEFINE FILE filename
SORTFLD/An = IF REGION NE 4 THEN REGION | CITY ELSE REGION;
END
TABLE FILE filename
SUM fields
BY SORTFLD
SUBTOTAL