In recent blog posts, we’ve looked at the pivot table Count function and the Average function. Now we’ll look at two more functions, that are closely related — Min and Max. Max Summary Function The Max summary function shows the maximum value from the underlying values in the Values area. The result is the same [...]

When you add a numeric data field to the Values area in a pivot table, the summary function defaults to either Sum or Count. You can change that field to use one of the other summary functions, such as Average. The Average Function The Average function in a pivot table works like the AVERAGE function [...]

When you add a field to the Values area of an Excel Pivot Table, it automatically shows the Sum or Count for all the items in that field. Here we can see the total labor cost for each Service Type. If you add more than one field to the Row Labels or Column Labels area [...]