Display Hidden Pivot Table Fields
To display hidden fields, use a simple or advanced Field List (to learn more about Field Lists, see Field List Overview).
First, invoke a Field List. For information on how to do this, see Invoke a Field List.
To display a hidden field, drag-and-drop the field from the Field List onto the required area of Pivot Table. This works for both simple and advanced Field Lists.
If you are using a simple Field List, you can display the required field as follows.
- Click the required field in the Field List.
- In the drop-down combo box, select a Pivot Table area within which this field should be displayed.
- Click the Add To button.
If you are using an advanced Field List, you can display a hidden field by dragging its header from the hidden fields section to the section corresponding to the required Pivot Table area.