Adding average to the pivot table

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

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

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