Exam 77-427 Microsoft Excel 2013 EXPERT
4. Create Advanced Charts and Tables
4.2 Create and Manage PivotTables: Manipulate PivotTables (Field Settings)

Edit the Field Settings

3. Try This. Change the Field Settings

Select Cell B3: Count of Amount.

Go to PivotTable Tools ->Analyze.

Go to the Active Field group.

Select: Field Settings.

 

graphic2

 

Keep going...

 

Memo to Self: In this example, the easy way to open the Field Settings is to double-click the Count of Amount Field Header on the PivotTable.

PivotTable Tools ->Analyze-> Active Field-> Field Settings

graphci1