Increasing the maximum number of pivot columns

By default, Wizard displays up to three pivot columns in the Pivot view. The maximum number can be increased up to five for more complex analyses.

To increase the maximum number of pivot columns:

1. In the Pivot view, choose Pivot > Set Number of Pivot Columns and select the desired number

See also:

• Adding a column to a pivot
• Reordering columns used in a pivot
• About the pivot drawer
• About the Pivot view

---

Back to Wizard Help