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:

• Adding a column to a pivot
• Partitioning a non-category covariate into discrete groups in the Summary view
• Partitioning a non-category data filter into discrete groups
• About the Pivot view

---

Back to Wizard Help