-
Access Pivot Tables..Charts - AutoCalc
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
-
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.
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules