Partitioning a non-category pivot column into discrete groups

By default, the pivot table attempts to break down non-category data into 6 groups of equal size for numeric and text pivot columns, and into durations of roughly equal length for date pivot columns. To change the partition:

  1. In the Pivot view, choose the pivot column you wish to configure
  2. Click the Configure button next to the pop-up button
  3. Use the controls in the popover that appears to define a new partition

See also:

Back to Wizard Help