pivot table of existing pivot table

G

Guest

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
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top