Custom Calculation in a Pivot Table
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 |
Custom Calculation in a Pivot Table
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. Skien wrote: 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 -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
All times are GMT +1. The time now is 01:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com