I want to do subtotals on department but instead of displaying the dept number
the user would like to see the department description.

ON DEPARTMENT_X SUBTOTAL AS ?????

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

Dave,

Try this:

  
-* File DaveZ01.fex
DEFINE FILE CAR
SEATER/A6=DECODE SEATS(2 SPORT 4 FAMILY 5 WAGON);
END
TABLE FILE CAR
SUM SALES 
BY SEATS
BY SEATER NOPRINT
BY CAR
ON SEATER SUBTOTAL AS SEATS
ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
 INCLUDE=ENDEFLT,
$
ENDSTYLE
END

You are saying I need to code for all 200 + departments

The other option is to use SUBFOOT.

ON DEP_CODE SUBFOOT
"<DEP_DESC <ST.Field1 <ST.Field2 <ST.Field3"  

You will need to do styling to position the items in the footing

Dave,

quote:

You are saying I need to code for all 200 + departments

I did a DECODE because in the CAR file there is no "description" for SEATS...

You probably have a field for the department name. Use that!

Thanks for all the help