I know there is an issue with pct.cnt , it needs an across, but I need to create a HOLD file for a graph. How do I obtain the total per group (subtotal) so I can use it in the hold file?

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

Gmal,

a car sample:

TABLE FILE CAR
SUM SALES AS SALESTOTAL_COUNTRY
BY COUNTRY
SUM SALES AS SALES_CAR
BY COUNTRY
BY CAR
ON TABLE HOLD AS HLD01 FORMAT FOCUS
END

You now have a HOLD file with both the sales per car and the total of sales for the country on each row.

G'luck

That worked perfectly, thank you!