Custom Totals In Pivot Table

I

Ifatooki

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
 
D

Debra Dalgleish

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

Ifatooki

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?







--
Debra Dalgleish
Contextureshttp://www.contextures.com/tiptech.html- Hide quoted text -

- Show quoted text -
Click to expand...

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
 
D

Debra Dalgleish

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 a custom subtotal, e.g. Sum, that will apply to all columns.
 
I

Ifatooki

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.







--
Debra Dalgleish
Contextureshttp://www.contextures.com/tiptech.html- Hide quoted text -

- Show quoted text -
Click to expand...

Now it works Thanks
 
Top