Creating new field in pivot table based off existing field

		Microsoft Office Forums > Microsoft Excel > Excel
Creating new field in pivot table based off existing field

FAQ

Thread Tools

Display Modes

06-26-2014, 12:13 PM

laceymarie1987 laceymarie1987 is offline

Windows 7 64bit Creating new field in pivot table based off existing field

Office 2010 64bit

Novice

Join Date: Jun 2014

Posts: 1

laceymarie1987 is on a distinguished road

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?

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:45 AM.