This will create an average for each season, and an overall average:

Double-click on the Season field button, and for Subtotals, choose
Average, then click OK
In the source data, add a column with the heading YTD, and leave all the
cells blank in that column.
Refresh the pivot table, and add the YTD field to the column area,
before Season
Double-click on the YTD field button, and for Subtotals, choose Average,
then click OK
Select the YTD cell that says (Blank), and type a couple of space
characters, then press the Enter key.


westy wrote:
Firstly - I am a big fan of this site, have searched previous questions and
just cant find/understand my problem.
My question - I want to obtain two averages from pivot table data displayed
in cells to the left of pivot table. They are an Average for the entire year
(Avg YTD B6:B8) and an Average for one season (Avg Aut C6:C8) against each
Name(A6:A8) from the Pivot table(D3:J17). The PT has two Field columns,
Season(E3) with two items Aut(E4) and Sum(H4) and Game(F3) with 6 items,
Games 1 - 3 for both seasons(E5:J5). Example Below

A B C D E F G H
I J
3 Runs Season Game
4 Aut Sum
5 Name Avg YTD Avg Aut Name 3 2 1 3 2 1
6 Kym ?? ?? Kym -6 5 4 8 6 7
7 Jimmy ?? ?? Jimmy 13 31 5 1 11 5
8 Craig ?? ?? Craig 15 2 11 8 19 17

So I want to display the average for the entire year (both seasons - Aut &
Sum) in Avg YTD and only for one season in Avg Aut. Also it needs to still
capture the averages as the PT updates and grows larger when the PT cells
expand to the left. More games will be added to the current season which in
this example will be Aut.

I have chosen to place the formulas outside and to the left of PT for
formatting reasons. I am happy to have them inside PT if they can be
displayed to the left. Also I want to maintain PT data and layout as in
example. Using 2003 version.

I hope I have explained this clearly and look forward to the always talented
response.



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