Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 55
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,766
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculated Field and Calculated Item in Pivot Table Fred Smith Excel Discussion (Misc queries) 0 March 4th 07 08:15 PM
HOW TO INSERT A CALCULATED FIELD TO MY PIVOT TABLE EXCEL 2003 drhell Excel Discussion (Misc queries) 1 January 29th 07 10:51 PM
pivot tables - insert calculated field Hilda B. Charts and Charting in Excel 0 November 6th 06 08:20 PM
pivot table formulas for calculated field or calculated item Vicky Excel Discussion (Misc queries) 3 June 6th 06 05:06 AM
Pivot tables - Insert Calculated field nc Excel Discussion (Misc queries) 0 May 9th 06 09:35 AM


All times are GMT +1. The time now is 04:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"