Hi,

Is there any way that bring the across-total first and then across fields

For Example

TABLE FILE CAR
SUM DEALER_COST
BY COUNTRY
ACROSS MODEL
ON TABLE ROW-TOTAL
END

in the above case ROW-TOTAL prints as last column
but I want ROW-TOTAL First followed by the across field values

Any suggestion?

Thanks

This message has been edited. Last edited by: Satya Dach,

Hi Satya and welcome to the Forum.
This should do the trick:

  
TABLE FILE CAR
SUM DEALER_COST AS TOTAL
BY COUNTRY 
SUM DEALER_COST
ACROSS SEATS
BY COUNTRY
ON TABLE SET ACROSSTITLE SIDE
END

Hi,

Thanks for the respond, in my code I can't use multi verb because it is a compound report and will impacts other reports. Is there any direct way like we use for subtotal like sub-total above?

Thanks

A way could be to create the across-column total then hold the result, create the across fields and hold the result, then match both files together.

Such as:

TABLE FILE CAR
SUM DEALER_COST AS 'DEALER_COST_TOT'
BY COUNTRY
ON TABLE HOLD AS TOT FORMAT FOCUS
END
-RUN

TABLE FILE CAR
SUM DEALER_COST
BY COUNTRY
BY SEATS
ON TABLE HOLD AS DET FORMAT FOCUS
END
-RUN

MATCH FILE TOT
SUM DEALER_COST_TOT
BY COUNTRY
RUN
FILE DET
PRINT SEATS
      DEALER_COST
BY COUNTRY
AFTER MATCH HOLD AS RESULT OLD-OR-NEW
END
-RUN

TABLE FILE RESULT
SUM DEALER_COST
BY COUNTRY
BY DEALER_COST_TOT
ACROSS SEATS
END
-RUN

Thanks got it, working as expected

Hi Satya,
Please change the title with [RESOLVED] in prefix.
So that if anyone has the same kind of issue, then they will follow the same steps to get it fixed.

Have a nice day...
Regards,
Suresh