Microsoft Office Tutorials and References
In Depth Information
Customizing Your Pivot Table
Figure 14-25: You want to remove Bikes from this analysis.
To hide the Bikes Business Segment, in the Business Segment drop-down list, deselect Bikes (see
Figure 14-26: Removing the check from the Bike items hides the Bikes segment.
After clicking OK, the pivot table instantly recalculates, leaving out the Bikes segment. As you can see
in Figure 14-27, the Market total sales now reflect the sales without Bikes.
Also note in Figure 14-27 that the filter icon next to Business Segment gives you a visual indicator
that a filter is being applied.
Figure 14-27: Segment analysis without the Bikes segment.