G
Geoff
Hi there
I have a dataset with earnings calculated by a field "class" and which I
have summarised in a pivot table by another field "group". I would like to
get a summary of the earnings data by group and then compare this with a
summary of the same data by group, with some classes excluded.
Is there any way to do this in the one pivot table, rather than by creating
two separate tables and comparing them? Ideally I would then be able to
create a calculated field in the one table.
Thanks
I have a dataset with earnings calculated by a field "class" and which I
have summarised in a pivot table by another field "group". I would like to
get a summary of the earnings data by group and then compare this with a
summary of the same data by group, with some classes excluded.
Is there any way to do this in the one pivot table, rather than by creating
two separate tables and comparing them? Ideally I would then be able to
create a calculated field in the one table.
Thanks