Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with Pivot Table Fields In Field List Not in Source Data
Hello, I typically do not use pivot tables and I have inherited one.
There are two fields, Month, and QTR, that are available in the field list but they are not fields from the source range? I am assuming there is a way to create a custom field that is a grouping of another, in this case date, however I cannot seem to find it. I checked the user formulas and there are none. Is there a way to find this? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with Pivot Table Fields In Field List Not in Source Data
You can group a date field by year, month, quarter, etc., and that will
create additional fields in the field list. There's information he http://www.contextures.com/xlPivot07.html To rename the fields, you can type over the default name on the field button, e.g. change Quarters to QTR. AP wrote: Hello, I typically do not use pivot tables and I have inherited one. There are two fields, Month, and QTR, that are available in the field list but they are not fields from the source range? I am assuming there is a way to create a custom field that is a grouping of another, in this case date, however I cannot seem to find it. I checked the user formulas and there are none. Is there a way to find this? Thanks -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem if Source field name of pivot table changes | Excel Worksheet Functions | |||
Pivot Table Field based on two data area fields | Excel Worksheet Functions | |||
Pivot Field in Field List but Not Source Data | Excel Discussion (Misc queries) | |||
How do I view Pivot Table source data file and field names? | Excel Discussion (Misc queries) | |||
Pivot Table - Data Source problem | Excel Worksheet Functions |