| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Calculated Field in a Pivot Table
I have some old instructions (nice pictures and all) of how to insert a new
formula field in a pivot table from Excel 2000 which is not the same in Excel 2003, which I am now using, and I can't find out how to do it, and Help is no help. In Excel 2000 you right-clicked on a column header in the Pivot Table and selected "Formulas" and then "Calculated Field...". But that option is not in the menu in Excel 2003. Where did it go? Connie |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Insert Calculated Field in a Pivot Table
Hi Connie
On the Pivot Table toolbar, select the dropdown labelled Pivot Table and you will see Formulas. -- Regards Roger Govier "Connie Martin" wrote in message ... I have some old instructions (nice pictures and all) of how to insert a new formula field in a pivot table from Excel 2000 which is not the same in Excel 2003, which I am now using, and I can't find out how to do it, and Help is no help. In Excel 2000 you right-clicked on a column header in the Pivot Table and selected "Formulas" and then "Calculated Field...". But that option is not in the menu in Excel 2003. Where did it go? Connie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you insert a calculated field within a pivot table | Excel Worksheet Functions | |||
| Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
| HOW TO INSERT A CALCULATED FIELD TO MY PIVOT TABLE EXCEL 2003 | Excel Discussion (Misc queries) | |||
| pivot tables - insert calculated field | Charts and Charting in Excel | |||
| pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
Linear Mode
