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'?
May 11, 2004, 03:28 PM
<Pietro De Santis>
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' ENDThis message has been edited. Last edited by: <Mabel>,
May 11, 2004, 03:32 PM
<eab>
Yes, I tried this but I have no total for Region 04, and it not helps with total for first 3 regions
May 12, 2004, 01:34 PM
<WFUser>
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