Pivot Table Help

[Ed]

I have a sheet that I use to keep track daily of the value of inventory by
day, and grouped by week. The value of the inventory is tracked by three
different subgroups. (Below is an example). On my piviot table the values
are grouped by type and by week. So what I get is a five day average of each
Type by week, which is exactly what I want. My averages are as follows:

M $796091.00
O $615069.00
R $3180669.00
===================
Grand Totals $1530609.00

The grand totals are where I need help. The grand total is an average of the
avaerages. Is it possible to display a sum of the averages?
Grand Totals $4591829.00

T.I.A.



Week Day Type Value
7-26 7-26 M 792144.00
7-26 7-26 R 3203807.00
7-26 7-26 O 611552.00
7-26 7-27 M 802286.00
7-26 7-27 R 3186100.00
7-26 7-27 O 618364.00
7-26 7-28 M 800191.00
7-26 7-28 R 3185773.00
7-26 7-28 O 616607.00
7-26 7-29 M 789741.00
7-26 7-29 R 3146994.00
7-26 7-29 O 613751.00

 

[Debra Dalgleish]

You could total the averages outside of the pivot table, but you can't
change the grand total within the pivot table.