defining Grouping

=?Utf-8?B?RG9uaWNh?=

Guest

Posts: n/a

13th Jul 2007

Pivot Table Grouping
If I have a defined grouping based on a set of number e.g.
Group Code
Group One = 23453
56773
23456
Group Two = 33333

When a new number is added to the pivot table data source – Code field
How can I group it into Group One without manually re-grouping?

Ideally an if statement to say if Code is not = to (<>) 33333 then Group One,
But I don’t know how to write it and more importantly where to put it.

Thanks for any and all help,

--
Regards,

Donica

« Alarm Timer | check.offset »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problem grouping Outlook emails with Outlook and not Word in thetaskbar grouping Options	sjurbanowski@hotmail.com	Microsoft Outlook Discussion	3	3rd Mar 2008 01:50 AM
Task Bar Grouping not working, box is checked, 11 windows, no grouping...HELP! TIA	ABDJCJ	Windows Vista General Discussion	0	31st Aug 2007 06:50 AM
Grouping and grouping within groups	j-giesler	Microsoft Excel Discussion	1	31st Jan 2006 08:31 AM
Defining	=?Utf-8?B?TWF0dA==?=	Microsoft Excel Misc	1	26th Jul 2005 08:13 PM
Defining name	howiechc	Microsoft Excel Discussion	2	26th Feb 2004 07:02 AM