Adding average to the pivot table


In this lesson you will learn how to add average column to the pivot table in Excel. Really useful and easy trick.

How to get average in pivot table?


1. Open the Excel sheet where your pivot table is created.

average data

2. Click anywhere on the pivot table. A PivotTable Fields box will appear.

PivotTable Fields

How to add an average in pivot table?

3. In the value box section, right click sum of quantity and click value field setting. A dialog box will appear. Select Average in the Summarize value by tab and click ok.

Summarize value field by Average

4. Drag quantity in the value box.

drag to value

5. Final result will be like this:

pivot table average added

Average column has been just added to the pivot table.


You can download the Template here – Download
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell