G
Guest
Pivot Table Grouping
If I have a defined grouping based on a set of number e.g. Field 1="Group"
Field2="Code"
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 don’t know how to write it and more importantly where to put it.
If I have a defined grouping based on a set of number e.g. Field 1="Group"
Field2="Code"
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 don’t know how to write it and more importantly where to put it.