SET PAGE=NOPAGE
TABLE FILE CAR
SUM
DEALER
BY BODYTYPE
ACROSS COUNTRY
SUM
SALES
BY BODYTYPE
ACROSS COUNTRY NOPRINT
ACROSS SEATS
END

I'm getting one DEALER column and then 9 SALES columns, I thought I'd get a DEALER column for each COUNTRY.

Francis,

The ACROSS statement in the first SUM is ignored. In multi-set requests you have only BYs, the ACROSSs affect only the last set.

Danny, thanks!

Thant's too bad.

Francis,

I can't resist sending you this:

  
-* File across2.fex
SET HOLDLIST=PRINTONLY
TABLE FILE CAR
SUM
DEALER
BY BODYTYPE
BY COUNTRY
SUM
SALES
BY BODYTYPE
BY COUNTRY 
BY SEATS
ON TABLE HOLD
END
TABLE FILE CAR
BY SEATS
ON TABLE SAVE
END
-RUN
-SET &SMAX=&LINES;
DEFINE FILE HOLD
-REPEAT #E FOR &I FROM 1 TO &SMAX;
-READ SAVE,&SEAT
-SET &T.&I=&SEAT;
SALE&I / I6 = IF SEATS EQ &SEAT THEN SALES ELSE 0;
-#E
END
TABLE FILE HOLD
SUM DEALER
-REPEAT #T FOR &I FROM 1 TO &SMAX;
SALE&I AS '&T.&I SEATER'
-#T
BY BODYTYPE
ACROSS COUNTRY
END

Hi Francis

It looks like your getting ACROSS SEATS, ACROSS EACH COUNTRY ?

This looks like you're getting what your code is describing, but removing the last "ACROSS SEATS" might get you closer to what you want ?

CL

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

Danny, clever use of DM!

Francis,

Do you NOT want a column for each "SEATS" that has data for each COUNTRY ?

Or, do you want an aggregate total for "ALL SEATS" for each COUNTRY ?

The first gives a Cartesian Product of SEATS x COUNTRY = # of columns in the output, if I understand you correctly ?

Is the second (aggregate) way that would give a single column per COUNTRY what you want ?

I'd like to see the solution that you find.
Thanks