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 your pivot
table?





Ifatooki wrote:
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

--
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