PC Review


Reply
Thread Tools Rate Thread

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

 
Reply With Quote
 
 
 
Reply

Thread Tools
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


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:03 PM.