Hi
I'm looking for some help in calculating the week, month and year average,
In 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...
is there a way to create this?
Thank you
Cthai
I'm looking for some help in calculating the week, month and year average,
In 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...
is there a way to create this?
Thank you
Cthai