My output
2 1
Week DC TRAINHRSMECH
1 T0551 612.05 555.27 649.17

Required Output

Total Total Regular
Week DC UA Hrs Mech Hrs Mech Hrs
1 T0551 555.27 649.17 612.05

This message has been edited. Last edited by: <Kathryn Henning>,

Hi Dipti,

Welcome to Focal Point.

If you shared some code and a screenshot that might help in understanding the question and the information you have provided so far.

To share code use the tool bar icons at the top and also refer to the "Forum Guidelines" for more information.

Kindest regards,
Tamra Colangelo
Focal Point Moderator
Information Builders Inc.

try this:
use a DECODE in a DEFINE to come up with alternate names for the columns
newcar/A10=DECODE CAR ('JAGUAR' 'want it' 'TOYOTA' 'got one' 'HONDA' 'no thanks' 'CHEVY' 'ru kidding'...);
SUM SALES ACROSS CAR NOPRINT ACROSS newcar AS ''