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:


Back to Wizard Help