•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to add a calculated (average) on to a Pivot Table
Hi Everyone,
Well, I'm determined to learn and I managed to get Pivot Table working. Here's a screenshot. It's two pivot tables.
The Average field that is populated was done automatically by the PivotTable. How do I add a last row to both to calculate the true average (not average of average)?
I'm still working on it, I don't have the monthly averages completed yet. I wouldn't mind assistance in getting that on the report either.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel compatibility
#row zero
#Excel alternatives for data analysis
#Pivot Table
#average
#calculated
#Excel
#monthly averages
#true average
#last row
#average of average
#report
#populated
#data analysis
#visualization
#assistance
#automatically
#fields
#feature