P
ponzonik
Hello. I'm having a bit of trouble the group function in a pivot
table.
Let's say we've got a table with columns "district" and sales (just an
example), and I create two different pivot tables with the same
origin. In one of the pivot tables I want to group regions in some
way, and define different sets in the second pivot table. Here comes
the issue: when I right click the selection...-> group, excel defines
a new property on the origin data, a new field called "district2".
That field also appears on the second pivot table. If I try to group
differently the "districts" in the second pivot table, instead of
generating another field called "district3" excel changes "district2"
according to the new grouping criteria. Bottom line: I can't have two
different groupings for the same field.
Is there any way I can overcome this? Say, by renaming the excel-
creating field "district2" before defining the new grouping?
Thanks!!!!
table.
Let's say we've got a table with columns "district" and sales (just an
example), and I create two different pivot tables with the same
origin. In one of the pivot tables I want to group regions in some
way, and define different sets in the second pivot table. Here comes
the issue: when I right click the selection...-> group, excel defines
a new property on the origin data, a new field called "district2".
That field also appears on the second pivot table. If I try to group
differently the "districts" in the second pivot table, instead of
generating another field called "district3" excel changes "district2"
according to the new grouping criteria. Bottom line: I can't have two
different groupings for the same field.
Is there any way I can overcome this? Say, by renaming the excel-
creating field "district2" before defining the new grouping?
Thanks!!!!