VBA calculation for Pivot table

Hello -

I'm looking for some help with a pivot table calculation...

i posted this on MrExcel [http://www.mrexcel.com/board2/viewtopic.php?t=281189] and i haven't found any answer yet, so i'm also posting it here hoping someone can help me with it...

my question and concern are:

'm looking for calculating the week, month and year average,

column A i have the dates (01-Apr-99 thru 01-Jan-06)
column B = Unit ID
column C = Owner name
column D = Plant ID plant ID would be use as a Key ID, since plant ID is different
column E = Plant Name
column F = Capacity offline (this is what i need to use to calculate)
column G = Type
column H = Unit type
column I = week
column J = month
column K = Year

I would like to create a pivot table where i can select a Plant ID and it would show me the average of the week, month and year... and all the other information...

anyone? I dont know if pivot table is the best way to do this - but i am open for any suggestion