Hi!. PLease help me to create a column name "Material"(MTNR) that I'm missing now
and line it up with accrossed WEEK values so it looks like this

Material 200743 200744 200745
------------------------------------------
ULTRAPLUSL 1.18 1.86 1.73
AAAAAAAAAA 1.18 1.86 1.73


Currently, I use AS ' ' to get around this, but I need "Material" as field name

TABLE FILE ACCROSSHLD
HEADING
"Weekly MIOH Report - Summary
SUM
MIOH
BY MATNR AS ' '
ACROSS WEEK AS ' '
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
TYPE=REPORT, SIZE=8,COLOR=BLACK, ORIENTATION=LANDSCAPE,
SQUEEZE=ON,GRID=OFF,$
TYPE=REPORT,JUSTIFY=CENTER,$
TYPE=TITLE, STYLE=BOLD, $
ENDSTYLE
END
________________________________________________________________
Weekly MIOH Report - Summary

200743 200744 200745
ULTRAPLUSL 1.18 1.86 1.73
_________________________________________________________________

And this is the output without AS ' ':

TABLE FILE ACCROSSHLD
HEADING
"Weekly MIOH Report - Summary"
SUM
MIOH
BY MATNR
ACROSS WEEK
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
TYPE=REPORT, SIZE=8,COLOR=BLACK, ORIENTATION=LANDSCAPE,
SQUEEZE=ON,GRID=OFF,$
TYPE=REPORT,JUSTIFY=CENTER,$
TYPE=TITLE, STYLE=BOLD, $
ENDSTYLE
END

_____________________________________________________
Weekly MIOH Report - Summary

WEEK
200743 200744 200745
MATNR
ULTRAPLUSL 1.18 1.86 1.73
_______________________________________________________

Thank you all! please respond to vkrugman@medline.com

This posting will most likely help you:

Column Heading with Across