Pivot Table calculation

[CThai]

Hello -

Looking for help calculating inside the pivot table -

I have a table that have different days of outage dates and I need to calculate the average of the "Capacity offline" by the day, week (Monday-Sunday) and month.

In the xls, I have outage date, owner name, plant name, plantID, Capacity offline, Type and Unit type...

PlantID will be use as the Key source since it is the same ID for all plant name and owner name...


I was able to create a pivot table but wasn't able to figure out how the calculation work...

codes for pivot table below,, please help

Please Login or Register  to view this content.

[Tarball]

I too had to do some calculations inside of a Pivot Table. I posted my question to this forum but ended up figuring it out on my own. Here is the link to the question and my answer. Calculations inside of Pivot Tables are really very straight forward.

http://www.excelforum.com/showthread.php?t=603362

[CThai]

Hi Tarball

Thanks for the link... I think by reading what you posted gave me an understanding of how it works... thanks again

[Tarball]

Very Cool! Happy Programming.

[Tarball]

Very Cool! Happy Programming. Its not very clear from my linked post but Sales and Units are fields within the Pivot Table. and the "=Sales/Units" part is the actual calculation.

Please Login or Register  to view this content.