PivotTable Fundamentals - Microsoft Business Intelligence Tools for Excel Analysts - page 29

Figure 2-16: Segment analysis without the Bikes segment.
You can just as quickly reinstate all hidden data items for the field. Choose Select All from the
Business Segment drop-down list. (Refer to Figure 2-15.) All the segments are now showing again.
Hiding or showing items without data
By default, your PivotTable shows only items that have data. This may cause unintended problems for
your data.
Look at Figure 2-17, which shows a PivotTable with the SalesPeriod field in the Rows area and the
Region field in the Filters area. Note that the Region field is set to (All), and every sales period appears
in the report.
Figure 2-17: All sales periods are showing.
If you display only Europe in the filter area, a portion of all the sales periods now show (see
Figure 2-18).