Custom Calculation in a Pivot Table

  • Thread starter Thread starter Skien
  • Start date Start date
S

Skien

Below are results from a pivot table. I cannot get the Total to calculate
correctly..
I inserted a calculated field within this pivot table with this formula
Column 1 = Column 3/Column 2, but Total is not right. Any help is
appreciated.


Task Name 1 2 3
A 10% 144 14
B 12% 144 17
C 14% 144 20
D 14% 144 20
Total 49% 144 71


Thanks
 
The total in column 1 is giving the correct percentage for 71/144.

Column 2 looks like it's also a calculated field, and that's why you're
not getting a total in that column. The total in column 2 will perform
the same calculation as all the other rows.

What's the calculation in column 2? Maybe you can calculate that in the
source data instead, and use that in the pivot table. Then the totals
should work as you expect.
 
Back
Top