Adding a column to a pivot

The controls below the pivot table can be used to manage columns in a particular pivot. To add a column to a pivot:

1. In the Pivot view, check one of the boxes below the pivot table labeled "Pivot column 1", "Pivot column 2", etc.
2. Select a column for the pivot using the pop-up button

Numeric and date columns can be further configured by clicking the Configure button next to the pop-up button. Note that non-category text columns cannot be used as pivot columns.

See also:

• Increasing the maximum number of pivot columns
• Creating a new pivot in the Pivot view
• Deleting a pivot from the Pivot view
• Reordering columns used in a pivot
• About the pivot drawer
• About the Pivot view

---

Back to Wizard Help