I have report which was created in Info Assist and must remain in Info Assist with the ability to open the report in the editor tool and make modified.

I have an across sort and 2 by sorts.
I also have 2 sum columns.

I need a grand total column however when I add a row total I am returning a row total for each of my count columns not an overall row count.

Is there an option I am missing.

Example

..............A........B........C........TOTAL
............SC..UU....SC..UU....SC..UU....SC..UU
Dodge Car1...1...3.....2...5.....4...4.....7..12
......Car2...4...1.....1...2.....4...6.....9..9
......Car2...4...3.....2...3.....6...6.....12..12

*I want the total column to be:
Total
19
22
17

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

Hi Lynsi,

How can you have

Total
19
22
17

when, as far as I understand your request and sample, it must be

Total
19
18
24

which is the total for last two columns (SC + UU) for each rows ?

This could be a way to perform what I think you want

TABLE FILE CAR
SUM COMPUTE GTOT/I9C = SEATS + UNITS; AS 'Grand Total'
BY COUNTRY
BY BODYTYPE
SUM SEATS/I4C
    UNITS/I7C
BY COUNTRY
BY BODYTYPE
ACROSS CAR
ACROSS-TOTAL AS 'Sub-Total'
WHERE BODYTYPE EQ 'SEDAN';
END

I've used the multi-verb option

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

Here's a more readable example:

..............A........B........C........TOTAL
............SC..UU....SC..UU....SC..UU....SC..UU
Dodge Car1...1...3.....2...5.....4...4.....7..12
......Car2...4...1.....1...2.....4...6.....9..9
......Car2...4...3.....2...3.....6...6.....12..12

Lynsi,

If I understand you well, you want to have a total column which sums the full row.
This is a solution (using the CAR file):

  
TABLE FILE CAR
SUM 
COMPUTE TOT=RCOST+DCOST; NOPRINT
BY COUNTRY
SUM RCOST DCOST
BY COUNTRY
ACROSS SEATS COMPUTE GTOT=TOT; AS Total
END