Pivot Tables
This section contains the following examples grouped by features.
Basic Actions
- How to: Create a Pivot Table
- How to: Refresh a Pivot Table
- How to: Change a Data Source for a Pivot Table
- How to: Move a Pivot Table
- How to: Clear or Remove a Pivot Table
Layout and Formatting
- How to: Subtotal Fields in a Pivot Table
- How to: Display or Hide Grand Totals for a Pivot Table
- How to: Change the PivotTable Layout
- How to: Format Numbers and Dates in a Pivot Table
- How to: Apply a Predefined Style to a Pivot Table
- How to: Apply a Custom Style to a Pivot Table
- How to: Control Style Options
Custom Calculations
- How to: Change the Summary Function for a Data Field
- How to: Apply a Custom Calculation to a Data Field
- How to: Create a Calculated Field
- How to: Create a Calculated Item
Sorting and Filtering
Grouping