Controlling the visibility of Fields in Pivot Tables

Hide Fields

Hiding All Fields

1. Right-click in the Header Section
2. Select Remove Fields From Filter Area

Hiding Individual Fields

1. Right-click in the Header Section
2. Select Show Field List

Show Fields

Process

1. Right-click in the Header Section
2. Select Show Field List

All Fields can be dragged into the Filter section
Filter Fields (text) can be dragged into Rows and Columns
Value Fields (numbers) can be dragged into the Data section

Want to learn more?

Online Help Manuals - Click here for the latest version

Learning Management System - Click here to login or here to request access