Total of 2 columns in pivot table
Hi
I have used a pivot table to work out and display the average/max of a set
of data twice for 2 different things so i have four columns in the data part
with two showing the average and another showing the max for an occurence and
and two other columns doing the same for a differnt occurence. I would like
to be able to add the two Average columns to have a total average and the two
Max columns to have a total max.
I got this to work by putting using the cells outside of the pivot table and
simply adding the cells. But is there a way of doing it so it is actually
part of the pivot table?
It looks a little like this
Ave 140 Max 140 Ave Multi Max Multi
23 25 20 20
25 25 20 20
Many thanks
|