| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| adding a pivot table to an existing worksheet- HELP!! | Excel Discussion (Misc queries) | |||
| Increasing the Source Data range for an existing Pivot Table | Excel Worksheet Functions | |||
| CELL RANGE SELECTION ON EXISTING PIVOT TABLE | Excel Worksheet Functions | |||
| How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
Hybrid Mode
