add the BY CAR after the first verb in j.g. solution and it works fine.

TABLE FILE CAR
SUM DEALER_COST NOPRINT
BY CAR
SUM DEALER_COST RETAIL_COST
BY CAR
ACROSS COUNTRY
RECAP DC_TOTAL=C1;
END

Hi JG and Spence,
Yes, this code works but I want the label to say as Total, Dealer, Cost.


Example:
TABLE FILE CAR
SUM DEALER_COST NOPRINT
BY CAR
SUM DEALER_COST RETAIL_COST
BY CAR
ACROSS COUNTRY
RECAP DC_TOTAL=C1; AS 'Total, Dealer, Cost'
END

The problem is, it is displaying Total Dealer Cost in one line. The comma is not working as how it works in Title(start in next line).

I just ran the code in our windows 5.3.4 and the title for the DC_TOTAL came out as three lines. Moment here, it is not removing the comma is what you're saying? I ran without the commas to HTML out and it wrapped the header but then that may be due to html.

quote:

DC_TOTAL

try this.

TABLE FILE CAR
SUM DEALER_COST NOPRINT
BY CAR
SUM DEALER_COST RETAIL_COST
BY CAR
ACROSS COUNTRY
RECAP 'Total Dealer Cost'=C1;
END

Hi Spence,
This code works. Thanks

Hi,

I used this solution because I didn't need a row total for all my across columns.

Worked great so thank you!

Now the problem...

At first, all the RECAPs were printing 2 decimals even if the original columns were not formatted that way. Then, I had to change the format of some of the columns so the $ would print. Now, my RECAP totals are size 10 font instead of size 8 like the rest of my columns (only the data, the titles are fine).

I've tried referring to them by Cn and by the field name. No dice. Any ideas?

Thanks,

Krysti

Nevermind. I got it to work.

I added a format to the RECAPs and it picked up the size 8 font. No idea why, but it did!