Edit the Field Settings

3. Try This. Change the Field Settings

Select Cell B3: Count of Amount.

Go to PivotTable Tools ->Options.

Go to the Active Field group.

Select: Field Settings.

 

 

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.

Exam 77-888: Microsoft Excel Expert 2010

3. Presenting Data Visually

3.3. Apply and manipulate PivotTables: Field Settings

PivotTable Tools ->Options-> Active Field-> Field Settings