| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Totals In Pivot Table
On Apr 30, 12:45 pm, Debra Dalgleish
wrote: If you leave the subtotals on Automatic, they should show the same summary function that's used in the column. So, in your example, three columns would show Sum in the subtotals, and three would show the average. If you use acustomsubtotal, e.g. Sum, that will apply to all columns. Ifatooki wrote: On Apr 27, 7:23 pm, Debra Dalgleish wrote: If the data field is summarized by Average, the total row should automatically show an average. What results are you seeing in yourpivot table? Ifatooki wrote: is it possible to produce a total row in apivottablethat 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 -- Debra Dalgleish Contextureshttp://www.contextures.com/tiptech.html-Hide quoted text - - Show quoted text - if is summarized by Average then all the data is Average, im trying to get the dollar amounts to sum and the averages to average in one row -- Debra Dalgleish Contextureshttp://www.contextures.com/tiptech.html- Hide quoted text - - Show quoted text - Now it works Thanks |
| 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
