How to Change From Sum to Count in a Pivot Table
- 1). Open the PivotTable report in your Microsoft Excel application. Click any cell in the data area so that it's highlighted.
- 2). Click the "Field Settings" option on the PivotTable toolbar. The "Sum" option will be selected by default in the PivotTable Field dialog box.
- 3). Click the "Count" option in the "Summarize by" box. The data will now be summarized by "count" instead of "sum."
- 4). Click the "Options" button to change any other field settings, such as adding a custom calculation.
- 5). Click the "OK" button in the PivotTable Field dialog box to save all of your changes.
