#1
|
|||
|
|||
Creating new field in pivot table based off existing field
I need to create a new field in an excel pivot table called "regions". These regions are based off the DistrictCode Field where district codes can be grouped in to a region. For instance, codes 7C, 8A, and 8 can be grouped in the Permian Region. Code 2,3,4,5,6,9,& 10 are Golf of Mexico. How to do I use the DistrictCode field to create a new Regional field?
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Form auto fill based on a different field value. | stct | Word | 31 | 05-02-2024 04:48 PM |
Excel Macro to "Select All" in Pivot Table Field | galkej | Excel | 0 | 02-03-2014 11:59 AM |
Field not showing in Pivot Table Field List | kmcovington | Excel | 0 | 10-26-2012 10:14 AM |
Excel Pivot Table Calculated Field | BertLady | Excel | 0 | 05-21-2012 10:51 AM |
field value based on time of day | akraw | Word | 3 | 03-26-2011 08:29 PM |