How to add Average to the Pivot table in Excel?
I have columns with count of Customers and count of orders. how can i show the average count of orders?
Upvotes: 2
Views: 24368
Answers (1)
Joe Skora
Reputation: 14921
Drop the orders column onto the Pivot layout again and then double click to select the summary method.
Upvotes: 4
Related Questions
- How to calculate average using calculated field in Excel Pivot Table?
- Average instead of Sum in Grand Total of Pivot Table in Google Sheets
- How do I switch from Sum of to Average on the Pivot Table?
- Excel Pivot table with more than one averaged value in rows
- Calculate average based on a value column (count) in a pivot table
- Calculating the running average in a pivot table
- How to add a weighted average in my pivot table?
- Add average column to Pivot Table SQL
- Sum of average column in PivotTable
- Adding average column in pivot table to be used as avg. line in pivot chart