Mar 3, 2004 #1 njjp Technical User Feb 18, 2004 5 US For pivot tables is there a way to to an average in the grand total fields instead of a sum?
Mar 3, 2004 #2 S SkipVought Programmer Dec 4, 2001 47,487 US Hi Right click the Grand Total heading and select whatever Summarize by: you like Skip, http://www.TheOfficeExperts.com Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 Upvote 0 Downvote
Hi Right click the Grand Total heading and select whatever Summarize by: you like Skip, http://www.TheOfficeExperts.com Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
Mar 4, 2004 Thread starter #3 njjp Technical User Feb 18, 2004 5 US I just want to change the calculation in the total colume to an average. Upvote 0 Downvote
Mar 4, 2004 #4 S SkipVought Programmer Dec 4, 2001 47,487 US Right click the Grand Total heading and select whatever Summarize by: you like Skip, http://www.TheOfficeExperts.com Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 Upvote 0 Downvote
Right click the Grand Total heading and select whatever Summarize by: you like Skip, http://www.TheOfficeExperts.com Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884