Grouping in Pivot Table

  • Thread starter Thread starter Piotr
  • Start date Start date
P

Piotr

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.
 
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.
Click to expand...
I cant modify source data as they come from transaction systems
I did ungruping and then i have grouped again.
thanks
 
Back
Top