Two problems: the table subtype is "Report" not "Summarize". You can check the subtypes by right clicking on the table entry in the outline and

choosing Copy OMS Subtype.

Second, pivot tables have to have row labels, but you can suppress these by making the row label width zero. This command will do that. SPSSINC MODIFY TABLES subtype='Report' /WIDTHS ROWLABELS=1 ROWLABELWIDTHS=0.

HTH,

Jon Peck Senior Software Engineer, IBM peck@us.ibm.com 312-651-3435

From: la volta statistics <schmidhauser@lavolta.ch> To: SPSSX-L@LISTSERV.UGA.EDU Date: 12/20/2010 08:00 AM Subject: [SPSSX-L] MODIFY TABLES with Summarize Sent by: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>

Dear all I am looking for a help to hide the column with 'cases' (the column most to the left) in my example. I tried Modify Tables, but couldn't find a way

to get rid of this column. I am using SPSS 18. TIA, Christian * Example: New File. DATA LIST FREE / Gender Hosp (2F8.0). BEGIN DATA 1 3 1 2 1 2 2 1 2 3 2 2 END DATA. SUMMARIZE /TABLES=Gender Hosp /FORMAT=VALIDLIST NOCASENUM TOTAL /TITLE='Table 1\n Gender Hospital' /MISSING=VARIABLE /CELLS=None. SPSSINC MODIFY TABLES subtype='Summarize' SELECT= 'Cases' DIMENSION= COLUMNS PROCESS = PRECEDING HIDE=TRUE. ********************************** la volta statistics Christian Schmidhauser, Dr.phil.II Weinbergstrasse 108 CH-8006 Zürich Tel: +41 (043) 233 98 01 Fax: +41 (043) 233 98 02 email: mailto:schmidhauser@lavolta.ch Web: www.lavolta.ch