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

Custom Totals In Pivot Table
 

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
Contextures
http://www.contextures.com/tiptech.html

Custom Totals In Pivot Table
 

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

Custom Totals In Pivot Table
 

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.

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



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

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