Grouping in Pivot Table

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

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.

Piotr wrote:
> 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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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
> field, and the items will appear in the correct group.
>
> Piotr wrote:
>
>> 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
>
>
>
I cant modify source data as they come from transaction systems
I did ungruping and then i have grouped again.
thanks