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