User Guide

274
Chapter 11
E
From the context menu choose Hide Category.
To Show Hidd
en Rows and Columns in a Table
E Select ano
ther label in the same dimension as the hidden row or column.
Forexample,iftheFemale category of the Gender dimension is hidden, click the
Male catego
ry.
E From the Pi
vot Table menus choose:
View
Show All Categories in dimension name
For example, choose Show All Categories in Gender.
or
E From the Pi
vot Table menus choose:
View
Show All
This displays all hidden cells in the table. (If Hide empty rows and columns is selected
in Table Pro
perties for this table, a completely empty row or column remains hidden.)
To Hide or Show a Dimension Label
E Activate the pivot table.
E Select the dimension label or any category label within the dimension.
E From the menus choose:
View
Hide (or Sho
w) Dimension Label
To Hide or Show a Footnote in a Table
E Select a footnote.