You can merge pivot labels using the Group feature. When combined, the data labels are aggregated, creating a new summary label category. With grouping, only your view of the data is changed. You can easily ungroup grouped categories and redisplay original label values.
For example, your pivot table is structured with data item Units (sold) dimensioned by Year and Quarter. You can group the first and second quarters together to summarize activity for the first half of the year. The data is aggregated in a new label.
To toggle the group dimensional label feature:
Select the individual labels to be grouped.
(You can group contiguous or discontiguous labels, but the labels must be part of the same dimension item or axis.)
Select (Un)Group Items on the shortcut menu.
The selected labels, and their associated data values or chart objects, are combined. The resulting label is displayed with an asterisk (*) to indicate a grouping.
To ungroup items, reselect the grouped items and choose (Un)Group Items on the shortcut menu.