Using a pivot table I can get sums for input and output for severa
factories in several places in several periods. But how can I get
mean productivity for the several totals by dividing output throug
input within the pivot table

--
Message posted from http://www.ExcelForum.com

Hi,
I believe you can use a Calculated Field to do that or maybe a CAlculated Item (but i think you are in the first case): right-click on the pivot and choose Formulas ... in the pop-up menu.
--
Regards,
Sébastien


"Arne Everhard " wrote:

Using a pivot table I can get sums for input and output for several
factories in several places in several periods. But how can I get a
mean productivity for the several totals by dividing output through
input within the pivot table?


---
Message posted from http://www.ExcelForum.com/