#1   Report Post  
Posted to microsoft.public.excel.misc
suepro
 
Posts: n/a
Default Pivot table items

How can I create new items in pivot tables with Office Professional 2003?
The formula option that used to be in the menu has been deleted. Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier
 
Posts: n/a
Default Pivot table items

Hi

It is still there.
highlight a field within your PT.
From the PT toolbar, use the dropdown Pivot Table, 9th item down Formulas,
from that sub-list, second entry, Calculated Item.

Regards

Roger Govier


suepro wrote:
How can I create new items in pivot tables with Office Professional 2003?
The formula option that used to be in the menu has been deleted. Thanks.

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
Change Data In Pivot Table John Calder New Users to Excel 1 July 7th 05 10:41 PM
How to view summarized items in a pivot table exceluser New Users to Excel 2 June 14th 05 03:10 AM
Pivot Table Problems Rachel Gonsior Excel Discussion (Misc queries) 3 March 21st 05 07:24 PM
Can't group pivot table items by month in Excel scott_ensley Excel Discussion (Misc queries) 1 February 1st 05 08:41 PM
Pivot Table - Group by Month - Show Items with no data Dan Reynolds Excel Discussion (Misc queries) 0 November 28th 04 01:01 AM


All times are GMT +1. The time now is 06:01 PM.

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

About Us

"It's about Microsoft Excel"