Microsoft Excel: Create A Report Showing Count, Min, Max, Average, Etc.

Written by: Mr Excel • Edited by: Tricia Goss
Updated Jul 23, 2008 • Related Guides: Microsoft | Microsoft Excel Help | Excel

Problem: All of the Pivot Table examples shown thus far are for summing revenue. What if you need to find out the average sale by customer or the smallest sale?

See all Microsoft Excel tips

Strategy:

Pivot tables offer a variety of calculation options. Double-click the Sum of Revenue button to change the calculation from Sum to any other calculation, as shown in Fig. 915.

Additional Information:
There is no built-in way to create a median for a pivot table. I’ve heard this question a few times. If you absolutely need to create a median in a pivot table, contact MrExcel Consulting – we’ve custom written pivot-table-like reports that do medians.
Summary:
Pivot tables can create averages; find the smallest sale, largest sale, and the number of sales. Use the Summarize By field in the PivotTable Field dialog.
Commands Discussed:
PivotTable

See all Microsoft Excel tips

Images