By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,641 Members | 2,101 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,641 IT Pros & Developers. It's quick & easy.

Calculate Average in Access Pivot Chart

P: 1
Is there way to show data as an average in Access pivot chart? It is currently defaulted to show sum for the data fields in the chart but I need to show the data as an average.
Aug 15 '12 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 5K+
P: 5,397
I must admit that crosstab and pivots are a week point for me; however, I do believe that the underlying query can be changed to use the average instead of sum or count within the data part of the query.

The following has the basic overview of how to do this:
Aug 15 '12 #2

Expert Mod 10K+
P: 12,365
In Access 2007, you right click one of the measure cells, go to autocalc, and select average.
Aug 15 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.