pivot table of existing pivot table
 

Hi
I want to caculate the average of one column in pivot table. I have to
create another pivot table on top of the existing one. How can I do it?
Thnks your help
Daniel

pivot table of existing pivot table
 

You can add another copy of the field to the data area, and change its
summary function to Average, instead of Sum.

If you give more details about what you're trying to do, someone may be able
to help you.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


"Daniel" wrote:

Hi
I want to caculate the average of one column in pivot table. I have to
create another pivot table on top of the existing one. How can I do it?
Thnks your help
Daniel