Access Pivot Tables..Charts - AutoCalc

[krishnak]

Hi All,

I am working on the Pivot Tables and Pivot Charts on the 2007 version.

I selected the data from a query to display the average value of 12 months of values for one criteria (e.g Overtime pcnt) for a group of offices on the X-axis. The bar chart shows the Offices on the X-axis and the Y-axis shows the count of the values (in this case 12) for each office.

I want the chart (or the Pivot Table) to display the Average value - but the only option in the AutoCalc is "Count". The rest of the options are grayed out. Count of the Overtime pcnt is meaningless as each Office will give a count of 12 for the year.

How can I change it to show Average and the number format as Percentage with two decimal places?
Thanks in advance
Krishna

[OBP]

Perhaps if you use a Double number for your Overtime pcnt field, i.e. 0.5 for 50% you may be able to then use Ave.

[krishnak]

The Overtime field has data in Double format upto 4 decimal places.
I am not able to change the criteria from Count to any other option - say Average, Maximum etc. It is so easy in Excel. Then the selection of format - Percent, Currency, Number etc will come into play.
I have spent a few hours on the problem, but still it beats me.