View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Neil Neil is offline
external usenet poster
 
Posts: 173
Default 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