Pivot comparison
 

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
--
There are 10 types of people in the world - those who understand binary and
those who don't.