| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Totals In Pivot Table
is it possible to produce a total row in a pivot table that will sum
one column and and produce the average of another? Sum Act$$ Sum Bud$$ Sum Var$$ Avg Act FTE Avg Bud FTE Avg Var FTE $291,507 $295,585 $4,078 31.6 226.0 4.45 $282,580 $296,518 $13,938 30.8 226.0 10.62 $277,728 $284,408 $6,680 31.2 226.0 7.70 $270,292 $284,408 $14,116 30.5 226.0 12.50 $264,553 $284,408 $19,855 30.1 226.0 15.07 $270,237 $284,408 $14,171 30.7 226.0 11.15 $276,933 $284,408 $7,475 31.0 226.0 9.21 $276,638 $285,230 $8,592 31.2 226.0 7.37 sum sum sum Avg Avg Avg |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Totals in Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot Table Chart - With Pivot Table Totals | Charts and Charting in Excel | |||
| Pivot Table Totals | Excel Discussion (Misc queries) | |||
| Pivot Table Totals | New Users to Excel | |||
| Totals For a Pivot Table?? | Excel Discussion (Misc queries) | |||
![Ifatooki[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
