Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
extra data for pivot table
Hi I have a pivot table that I have named a few extra columns as spare1
spare2 etc. These will be used for future categories in which we may want to use for data. I have dragged these over to the pivot table however when I change the name on the master sheet where the pivot range is defined the data field originally called spare1 (now called "training extras") dragged over to the data field is removed from the data. Is there a way that I can keep the field in the data area if I change Spare1 title to another name on the pivot range? Any help is appreciated Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Expanding a data table to include an extra row | Excel Discussion (Misc queries) | |||
How do I change my data or add extra rows in a Pivot Table for Ex. | Excel Discussion (Misc queries) | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
How do I sort pivot table data outside a pivot table | Excel Worksheet Functions | |||
How to pull extra info into Pivot table report | Excel Worksheet Functions |