You can group items in DataPilot tables from the pop-up
menu of the Row area and Column area.
- To group items in DataPilot table:
- Select the items in a field that you want to group.
- Right-click the Row Area or Column Area, and select Group
Selected Items. The items are grouped as Group1, Group2,
Group3...You can change the group name on the DataPilot table directly.
- To group date or numeric items in DataPilot table:
- Put focus on the date or numeric fields and select the
items to group.
- Right-click the Row Area or Column Area, and select Group
Date or Numeric Items.
- Specify the start of the grouping. Select Automatically if
you want to start grouping at the smallest value. Select Manually
at if you want to enter the start value for grouping yourself.
- Specify the end of the grouping. Select Automatically if
you want to end grouping at the largest value. Select Manually
at if you want to enter the end value for grouping yourself.
- Specifies the value range by which limits of every group
are calculated. When you group date values, two options are available:
- Number of days
- Specifies the number of days to group by.
- Intervals
- Specifies the intervals to group by.