I would like different columns subtotalled for different BY fields, but it doesn't work. Please see this example, where for COUNTRY, I only want SALES subtotalled and for CAR I want SALES and WEIGHT subtotalled.

The specified list of fields for COUNTRY are overridden by the specified list of fields for CAR.

TABLE FILE CAR
SUM
SALES
WEIGHT
HEIGHT
BY COUNTRY SUBTOTAL SALES AS 'TOTAL COUNTRY - '
BY CAR SUBTOTAL SALES WEIGHT AS 'TOTAL CAR - '
END

This message has been edited. Last edited by: Francis Mariani,

I'd keep the totals in defined fields, or COMPUTE ... NOPRINT, and use them in "ON {FIELD} SUBFOOT". Wouldn't that work here?

Thanks, but I sure wish we didn't have to rely on the old SUBFOOT solution. The manual does not state that what I want to do does not work...

Things aren't always as they seem... Especially considering Technicalities. Maybe in WF8?

I think the questions is "should it work", and if so, techsupport needs to know that it doesn't.

SET SUMMARYLINES = EXPLICIT
TABLE FILE CAR
SUM
 SALES
 WEIGHT
 HEIGHT
BY COUNTRY SUBTOTAL SALES AS 'TOTAL COUNTRY - '
BY CAR SUBTOTAL SALES WEIGHT AS 'TOTAL CAR - '
END

It's in the documentation for the SUMMARYLINES parameter. The default puts fields in any subtotal into all subtotals.

Awesome.

Seems this came in, in version 5.32

Nick,
Nice going for your FIRST post. Congratulations.
If I may add:
The SUMMARYLINES setting does not work within a TABLE command.
Default is OLD; and there are 2 other values, NEW and EXPLICIT, that differ in the way they propagate to higher levels and to grand totals.

Yes, Waz, quite useful...

Learn something new all the time.

Nick, thanks for that! We're always learning.
Is it a tossup between NEW and EXPLICIT? I'll test this.

Cheers,

hmmm .... the puzzle becomes... 'who is Nick Hilt'? sounds like a movie title..

holy smokes. This is the awesome. Thanks, Nick.

Yup, EXPLICIT does the job.