Manipulating Pivot Tables
- Mark Significance Levels in Tables Script to highlight significant statistics in Pivot Tables
- Set number decimals of percentages in PivotTable
- Undo percent notation
- Remove pivot table row and column labels
- Applying any script to all pivot tables
- Automation of pivotting Examples to learn how to manipulate layers, columns and rows
- Autoscript to format correlation table
- Change Format Means Report
- Change Format Means Report Change number format in Means procedure report
- Change Sig to P This script changes Sig. to p in the column labels of any pivot table
- Combine mean and SD (used by the syntax, see the link below)
- Combine Mean and SD (to demonstrate how the scrip works)
- Create pivot table
- Crop and retain
- Cycling through all layers of a table
- Define customized crosstab titles
- Delete footnotes of all Pivot Tables
- Exchange rows and columns of Pivot Table
- Hide valid and valid percentage in frequency table
- Hide a column in pivot table
- Highlights significant cells of all ANOVA tables in Designated Viewer
- Highlight significant T-Test cells
- Italize percentages in PivotTable
- Left right or center justify title of all pivot tables
- Create pivot table-ROC (to be called by syntax)
- Create pivot table-ROC Syntax used to demonstrate how the script works
- Make totals bold
- Make Totals Bold All Pivot Tables
- Pivoting to each layer of a pivot table
- Remove percent signs from PivotTable
- Replacing Empty Cells of Pivot Tables by user-defined characters
- Rotate inner labels of all visible PivotTables
- Round frequencies in crosstab tables
- Reverse columns order
- Ungroup a column in a pivot table
- Set number of decimals in pivot table
- Substitute string in pivot tables
- Table Widths Manipulating width of columns of tables
- Table Widths
- Undo Scientific (##.#E±##) Notation Script to change scientific notation in tables
- Traffic Light Color coding of Pivot Table cells based on their values and defined margins
- Traffic Light with Fixed Margins 15 and 25 (without dialogs, margins are hard-coded)
- Traffic Light with 3 Cut Off Points Color Pivot Tables cells based on values, 3 cut-off points
- Autoscript to format correlation table Adapted for SPSS 16+.
Related pages
...