Overview/Basic Formatting
Introduction to Blocks
Creating Crosstabs
Using the Crosstab Wizard
Using Slice-and-Dice
Displaying Row and Column Headers
Pivoting/Swapping Headers
Removing Headers
Replacing Headers
Displaying Multiple Objects in Headers
Effect of Adding Objects to the Query
Inserting Objects in the Body of the Block
Removing Objects from the Body of the Block
Breaking
Break and Formula
Calculations in Slice-and-Dice
Ranking
Ranked Variable with Break
Sorting
Grouping in Headings
Filtering on Heading
Variances
Sum of the Variance
Creating Variables
Running Sum
If-Then-Else
Inserting Master Cells
Creating Summary Cells
Creating Master Cells
Adding Summary Cells to Master
Saving Report to Excel
Alerters and Drilling and Charts
Cell Format Alerter
Text Format
Variable Format
Applying Alerters to Crosstab Body
Applying Alerters to Crosstab Headers
Editing and Reformatting Alerters
Applying Different Types of Alerters
Drilling on Blocks
Hierarchies
Drill Mode
Single Dimension Drilling in Headings
Multiple Dimension Drilling in Crosstab Body
Drill Options Up, Down, Across
Converting to Chart