Sidebar Sidebar
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

pivot table average of sums.

U

uplift123

macrumors newbie
Original poster
Mar 9, 2011
7
0
Is it possible to add a column to a pivot table that shows an average of the sums. I'm trying to calculate an average spend per category per month. I'd like "Grand Total" to instead display an average of each month's sum for each category. Picture attached for context. Thanks

Screenshot 2023-03-20 at 14.20.55.png
 
You must log in or register to reply here.
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.
Top Bottom
Back