Page 13 of 25PREVNEXT

PivotTable III: Show off your PivotTable skills

Select Count in the PivotTable Field dialog box

Changing the summary from Sum to Count in the PivotTable Field dialog box.

To change the Sum to a Count, select a different summary function in the Summarize by list:

  1. Click in one of the cells that says Sum of Order Amount2.
  2. Click the Field Settings button Button image on the PivotTable toolbar.
  3. Select Count in the Summarize by list.

Notice in the picture that when Count is selected, the text in the Name box in the dialog box changes to Count of Order Amount2.

Tip     The Summarize by list contains other summary functions such as Average, Max, and Min.

Page 13 of 25PREVNEXT