If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access Pivot Table HELP!: calculated columns
There doesn't seem to be much information around about Access Pivot Tables,
and I don't do much in Excel. MS Help is no help whatsoever. I'm trying to create two columns: average units and average price, and everything I try comes up with errors. One manual says I should be able to click on a column (Units), then click on Autocalc and choose a function (like Avg), but when i click on a column, Autocalc is grayed out. ???? Then if I try to create a calculated field, detail or total, I get the Properties/ Calculation box, and have used Insert Reference to create a calculation (NetCharge / Units). However, the results are horribly inconsistent: sometimes the calculation is correct and sometimes not. (I have to perform this calculation at a total level, because some entries may have a charge but no units, as when a charge adjustment has been made. I can't do the calc at a detail level in the underlying query/table.) Very frustrating, very confusing, for something which has the potential to be a very useful tool. Any help gratefully appreciated. Kevin |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mixed up with Relationships..help! | KrazyRed | New Users | 3 | January 26th, 2005 05:03 AM |
Pivot Table Access 2000? | Air-ron | General Discussion | 2 | October 29th, 2004 06:19 PM |
Pivot Table Calculated Fields ?? | Corey | General Discussion | 1 | September 23rd, 2004 12:11 AM |
Pivot table drops columns on refresh | Jason | General Discussion | 1 | July 1st, 2004 02:18 PM |