Hope someone can help - I've spent hours trying to insert a calculated field item into a pivot table - I need to insert an extra column in the pivot table (not outside!) that contains a formula for the data produced in other fields (to the left). I have tried creating pivot fields in the 'calulated field' option under 'formulas'. However, the only result returned is '0's. If I click on 'Calculated item' I keep getting an error message that does not make any sense. Is this a bug in Excel 2000 or is there a way of doing this seemingly straightforward task??