ExcelBanter - How do you insert a calculated field within a pivot table

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do you insert a calculated field within a pivot table (https://www.excelbanter.com/excel-worksheet-functions/219048-how-do-you-insert-calculated-field-within-pivot-table.html)

Mandy

How do you insert a calculated field within a pivot table

I am trying to insert a calculated field within a pivot table in Excel 2007
and cannot find this command. This was available within Excel 2000

Ashish Mathur[_2_]

How do you insert a calculated field within a pivot table

Hi,

When your cursor is in the pivot table, please navigate to Options Tools
Formulas.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"mandy" wrote in message
...
I am trying to insert a calculated field within a pivot table in Excel
2007
and cannot find this command. This was available within Excel 2000

All times are GMT +1. The time now is 01:10 AM.