Pivot table calculation

  • Thread starter Thread starter Arne Everhard
  • Start date Start date
A

Arne Everhard

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Playing back a Pivot Table macros 2
Unable to Group in Pivot Table 1
Pivot table multiple filters 2
Passing Criteria to a Pivot Table from combo boxes 3
Pivot table "Sum of" or "Count of" 1
Pivot table code question 2
Automatically Update a Pivot Table Field Used as Column / Row 1
Excel 2010 Pivot Table 2

Back
Top