Grouping rows or columns ................................................................................................................ 130
Ungrouping rows or columns.............................................................................................................130
Rotating row or column labels...........................................................................................................130
Sorting rows....................................................................................................................................... 130
Inserting rows and columns.............................................................................................................. 131
Controlling display of variable and value labels................................................................................131
Changing the output language...........................................................................................................131
Navigating large tables...................................................................................................................... 132
Undoing changes................................................................................................................................132
Working with layers................................................................................................................................. 132
Creating and displaying layers...........................................................................................................132
Go to layer category........................................................................................................................... 133
Showing and hiding items....................................................................................................................... 133
Hiding rows and columns in a table...................................................................................................133
Showing hidden rows and columns in a table...................................................................................133
Hiding and showing dimension labels............................................................................................... 133
Hiding and showing table titles......................................................................................................... 133
TableLooks...............................................................................................................................................133
To apply a TableLook......................................................................................................................... 134
To edit or create a TableLook............................................................................................................ 134
Table properties...................................................................................................................................... 134
To change pivot table properties.......................................................................................................134
Table properties: general...................................................................................................................134
Table properties: notes......................................................................................................................135
Table properties: cell formats........................................................................................................... 135
Table properties: borders.................................................................................................................. 136
Table properties: printing.................................................................................................................. 136
Cell properties......................................................................................................................................... 137
Font and background......................................................................................................................... 137
Format value.......................................................................................................................................137
Alignment and margins...................................................................................................................... 137
Footnotes and captions...........................................................................................................................137
Adding footnotes and captions..........................................................................................................137
To hide or show a caption.................................................................................................................. 137
To hide or show a footnote in a table................................................................................................ 138
Footnote marker.................................................................................................................................138
Renumbering footnotes..................................................................................................................... 138
Editing footnotes in legacy tables......................................................................................................138
Data cell widths....................................................................................................................................... 139
Changing column width........................................................................................................................... 139
Displaying hidden borders in a pivot table..............................................................................................139
Selecting rows, columns, and cells in a pivot table................................................................................139
Printing pivot tables.................................................................................................................................140
Controlling table breaks for wide and long tables............................................................................ 140
Creating a chart from a pivot table..........................................................................................................141
Legacy tables........................................................................................................................................... 141
Chapter 12. Models............................................................................................143
Interacting with a model......................................................................................................................... 143
Working with the Model Viewer......................................................................................................... 143
Printing a model.......................................................................................................................................144
Exporting a model....................................................................................................................................144
Saving elds used in the model to a new dataset.................................................................................. 144
Saving predictors to a new dataset based on importance..................................................................... 145
Ensemble Viewer..................................................................................................................................... 145
Models for Ensembles........................................................................................................................145
Split Model Viewer...................................................................................................................................147
vii