Hi,

In most of the reports, we do display sub-total and grand totals..... But how do we show what is the contribution of one subtotal with respect to the total

e.g

Total for NY is 100
Total for MN is 100
Total for PA is 100

Total for USA is 300

% of NY is 34 %
% of MN is 34 %
% of PA is 34 %


I hope I am clear with my question

Thanks,
Navaneeth

Navneeth -
Please lookup the " WITHIN " verb. That will show you how to get the grand-total as a column with-in the same Hold file, and use it for calculations like these.

Best regards,
Sandeep Mamidenna

You can also use a multiverb such as:
DEFINE FILE CAR
TOT_SLS/D12=SALES;
END
TABLE FILE CAR
SUM TOT_SLS NOPRINT
SUM SALES
COMPUTE PCT_SLS/D5%=SUM.SALES/TOT_SLS * 100;
BY COUNTRY
END