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 dont know how to write it and more importantly where to put it.

Thanks for any and all help,

--
Regards,

Donica