I am trying to list some itemcodes from the ones that make the most profit to the least BY DEPARTMENT and BY CLASS... I sum the items BY ITMECODE becuase some of the items were ordered more then once. After I get the Total profit column and try to add a BY TOTALPROFIT column it seems to be puting them in the order of the highest totalprofit before they were summed...

EX.
before sum
BY TOTALPROFIT
ITEMCODE___#ofOrders____TOTALPROFIT
12346______1____________2.00
12346______1____________2.00
12346______1____________2.00
12347______1____________1.75
12347______1____________1.75
12347______1____________1.75
12345______1____________1.25
12345______1____________1.25
12345______1____________1.25
12345______1____________1.25
12345______1____________1.25


after SUM
then BY TOTALPROFIT
ITEMCODE___#ofOrders____TOTALPROFIT
12346______3____________6.00
12347______3____________5.25
12345______5____________6.25

I believe it is because there original values would put them in this order

I don't know how to put them in the correct order after they are summed

Thanks for the help!

This message has been edited. Last edited by: Charles Richards,

FILEDEF DATAMAST DISK DATA1.MAS
-RUN

-WRITE DATAMAST FILE=DATA1, SUFFIX=FIX, $
-WRITE DATAMAST SEGNAME=SEG1, SEGTYPE=S0, $
-WRITE DATAMAST   FIELD=ITEMCODE   , ALIAS=E01, USAGE=A5    , ACTUAL=A5, $
-WRITE DATAMAST   FIELD=FILL1      , ALIAS=   , USAGE=A1    , ACTUAL=A1, $
-WRITE DATAMAST   FIELD=#ofOrders  , ALIAS=E02, USAGE=I4    , ACTUAL=A1, $
-WRITE DATAMAST   FIELD=FILL2      , ALIAS=   , USAGE=A1    , ACTUAL=A1, $
-WRITE DATAMAST   FIELD=TOTALPROFIT, ALIAS=E03, USAGE=P10.2 , ACTUAL=A4, $

FILEDEF DATA1 DISK DATA1.FTM
-RUN
-WRITE DATA1 12346 1 2.00
-WRITE DATA1 12346 1 2.00
-WRITE DATA1 12346 1 2.00
-WRITE DATA1 12347 1 1.75
-WRITE DATA1 12347 1 1.75
-WRITE DATA1 12347 1 1.75
-WRITE DATA1 12345 1 1.25
-WRITE DATA1 12345 1 1.25
-WRITE DATA1 12345 1 1.25
-WRITE DATA1 12345 1 1.25
-WRITE DATA1 12345 1 1.25
-RUN

TABLE FILE DATA1
SUM
#ofOrders
TOTALPROFIT
BY TOTAL HIGHEST TOTALPROFIT NOPRINT
BY ITEMCODE
END
-RUN

Thank you so much! all i needed was to TOTAL before HIGHEST

in the line

BY TOTAL HIGHEST TOTOALPROFIT

Nice and quick, eh?

Yea thanks so much, Your the Man!