Is there any way to get RPCT. columns to subtotal correctly? I've tried SUMMARIZE and RECOMPUTE and all I get are the sums of the percentages. What I want, of course, are the percentages for the subtotal rows.

TABLE FILE CAR
SUM SEATS
RPCT.SEATS/D8.2%
BY COUNTRY SUMMARIZE
ACROSS BODYTYPE
END

SET SUMMARYLINES has no effect. Is there some option or command I'm missing? I'll appreciate any and all help.

Unfortunately, I don't think you're missing an option or command - rather, it is WebFOCUS that is missing something!

Here's one way - calculate the percentage:

TABLE FILE CAR
SUM SEATS NOPRINT
BY COUNTRY
SUM SEATS
COMPUTE SEATSPCT/D8.2% = SEATS / C1 * 100; AS '%'
BY COUNTRY SUMMARIZE
ACROSS BODYTYPE
END

I hope someone proves me wrong, but the only other way would be to use FRL to resolve this simple task.

Francis is correct. SUMMARIZE/RECOMPUTE do not recalculate the RPCT. prefix on the total lines. Just for fun I tested the MAX. prefix operator and the same is true for this one as well. It seems the prefix operators are calculated as the internal matrix is being built or at some interim level before COMPUTEs. This is probably why they cannot act like or be treated as true COMPUTE fields which are affected correctly by SUMMARIZE/RECOMPUTE.

I suggest using Francis' technique.

And if you don't like the use of the column coding (C1) you can create an extra field SEATS1 and use that in the code like

DEFINE FILE CAR
SEATS1=SEATS;
END

TABLE FILE CAR
SUM SEATS1 NOPRINT
BY COUNTRY
SUM SEATS
COMPUTE SEATSPCT/D8.2% = SEATS / SEATS1 * 100; AS '%'
BY COUNTRY SUMMARIZE
ACROSS BODYTYPE
END

Thank you very much. This was exactly what I needed. I was hoping I was missing something that didn't require a lot of extra coding - and I was. Although I don't mind the column technique, I'll make it easier for someone else who may have to maintain my code at some later date and be more explicit. Thanks again Francis, Mickey, and Frank.