I have a report in which i have 2 across fields the code is given below

TABLE FILE ENRIS_TRPT_GEO_DEFECT
SUM
CNT.DEF_TYPE AS ''

BY
DIVISION_NAME AS 'Division'
BY
LINE_SEG_NBR AS 'LS'
BY
TRACK_TYPE AS 'TkType'
BY
TRACK_SDTK_NBR AS 'TkNo'


ACROSS
DEFTYPE AS ''

ACROSS YEARDT AS ''

the output is like this
def1 def2 def3
2000 2001 2000 2001 2000 2001
Division LS TKno TkType
chicago 1 1 M 1 0 0 2 1 1
califor 1 1 M 1 0 0 2 1 1



I want to display total of all defs' by year like below


def1 def2 total
00 01 00 01 00 01
Division LS TKno TkType
chicago 1 1 M 1 0 1 2 2 2
califor 1 1 M 1 0 0 2 1 2


How can we do this . Can anyone help me ASAP

Difficult to read your output

Can you use ROW-TOTAL?

ACROSS-TOTALread this thread
and then do a search on this forum
(FIND) on ACROSS TOTAL and you'll find lots of help

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