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