I have a cross report for country. How can I hide the column for JAPAN without losing my total.

here is the sample using a CAR file
TABLE FILE CAR
SUM
CAR.BODY.SALES
BY CAR.COMP.CAR
BY CAR.CARREC.MODEL
ACROSS LOWEST CAR.ORIGIN.COUNTRY ACROSS-TOTAL
ON TABLE COLUMN-TOTAL AS 'TOTAL'
END

This message has been edited. Last edited by: <Emily McAllister>,

What should Total be if your report hides JAPAN?

I assume you don't like the total when you have:
WHERE COUNTRY NE 'JAPAN';

I will also need the grand total amount including JAPAN

There's a way to specify which values are included in the report, but I think it takes the non-selected columns out of the totals as well.

Multi-part report where the second captures the total numbers and presents them separately?

John,

How do specific which columns are included in the report?
If I can hide what I don't need. Then, I can do a manual define to calculate the totals.

thanks,

Vera

It's in the Help files for ACROSS COLUMNS AND as this --

TABLE FILE EMPLOYEE
SUM CURR_SAL
ACROSS BANK_NAME COLUMNS 'BEST BANK' AND STATE
AND ASSOCIATED AND 'BANK ASSOCIATION'
END

Sort of a bugger to find unless you know it's there.

using column notation {eg Cn, also Pn, )

SET ASNAMES = ON
TABLE FILE IBISAMP/CAR
SUM SALES AS TOTSALES 
  
SUM SALES   BY COUNTRY 
ON TABLE HOLD
END
 TABLE FILE HOLD PRINT *
END
TABLE FILE HOLD SUM TOTSALES NOPRINT SALES ACROSS COUNTRY AND COMPUTE TOTAL=C1;
IF COUNTRY NE 'FRANCE'
END

where C1 is the first column after the first verb, and you have NOPRINTed that column, but the internal matrix still can use it just fine

See what happens with
WHERE TOTAL COUNTRY NE 'JAPAN';

thanks Susan