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

written by: Mr Excel•edited by: Tricia Goss•updated: 7/23/2008

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?

• slide 1 of 2

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.

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

• slide 2 of 2