Pin Me

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

    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

  • slide 2 of 2

    Images

    Fig. 915