| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem inserting calculated pivot fields into Pivot Table (2007)
Working with Excel 2007 and a Pivot Table. Created a Calculated field. The
field shows in the Field List, but Excel will not let me drag the Calculated field into the Pivot Table areas (other than into the Values area). What am I doing wrong? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Problem inserting calculated pivot fields into Pivot Table (2007)
Hi
A calculated item or field, can ONLY be allocated to the data area. It's position within the data area can be modified, but it cannot be moved to any other area -- Regards Roger Govier wamiller36 wrote: Working with Excel 2007 and a Pivot Table. Created a Calculated field. The field shows in the Field List, but Excel will not let me drag the Calculated field into the Pivot Table areas (other than into the Values area). What am I doing wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 - Pivot Table and Calculated fields? | Excel Worksheet Functions | |||
| pivot table calculated fields | Excel Discussion (Misc queries) | |||
| Pivot Table Calculated Fields | Excel Discussion (Misc queries) | |||
| Pivot table and calculated fields | Excel Discussion (Misc queries) | |||
| Pivot Table with Calculated Fields | Excel Discussion (Misc queries) | |||
Hybrid Mode
