To change the Sum to a Count, select a different summary function in the Summarize by list:
- Click in one of the cells that says Sum of Order Amount2.
- Click the Field Settings button on the PivotTable toolbar.
- 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.