hello,

Hope someone can help met with the following problem.
I don't want a specific row to be printed.

TABLE FILE CAR
SUM LICENSEPLATE AS 'Number of cars'
BY BRAND
ON TABLE SUMMARIZE LICENSEPLATE
END

How can I get rid of the row 'AUDI' without effecting the summarized total?

Thanks for your help!

Richard

This message has been edited. Last edited by: Kathleen Butler,

Could be one way

TABLE FILE CAR
SUM SEATS
BY TOTAL COMPUTE ROWID /I1  = 1;
BY CAR
WHERE CAR NE 'AUDI';
ON TABLE HOLD AS TMPDET FORMAT FOCUS
END
-RUN

TABLE FILE CAR
SUM SEATS
BY TOTAL COMPUTE ROWID /I1  = 2;
BY TOTAL COMPUTE CAR   /A16 = 'TOTAL';
ON TABLE HOLD AS TMPTOT FORMAT FOCUS
END
-RUN

TABLE FILE TMPDET
PRINT SEATS
BY ROWID NOPRINT
BY CAR
MORE
FILE TMPTOT
END
-RUN

Thanx!
I will try this.

Richard,

pretty cool, having a "CAR" sample file in your line of business ;-)