Custom Calculation in a Pivot Table

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
 
D

Debra Dalgleish

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.
 

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

Top