Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / May 2005

Tip: Looking for answers? Try searching our database.

Grouping in Pivot Table

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Piotr - 16 May 2005 17:15 GMT
Hello
I have spend few hours and I ave lost.
The problem is as follow:

I have pivot table grouped
Group I
    ...items
    ...items
Group II
    ...items
    ...items

When new item appears:
Group I
    ...items
    ...items
Group II
    ...items
    ...items
new item

The problem is how to add "new item" in to existing Group, becouse  when
I try to add item to the group the new group is created.

regards
Peter
Debra Dalgleish - 16 May 2005 21:13 GMT
Instead of grouping the items in the pivot table, you could add a
"Group" field to the source data. Then, add that field as the first row
field, and the items will appear in the correct group.

> Hello
> I have spend few hours and I ave lost.
[quoted text clipped - 22 lines]
> regards
> Peter

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Piotr - 17 May 2005 19:09 GMT
Użytkownik Debra Dalgleish napisał:
> Instead of grouping the items in the pivot table, you could add a
> "Group" field to the source data. Then, add that field as the first row
[quoted text clipped - 26 lines]
>> regards
>> Peter

I cant modify source data as they come from transaction systems
I did ungruping and then i have grouped again.
thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.