Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,979
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Calculation Silena K-K Excel Discussion (Misc queries) 0 March 17th 08 07:49 PM
custom calculation in Mutiple consolidation pivot table sherobot Charts and Charting in Excel 0 May 9th 07 04:14 PM
% of subtotal custom calculation in a pivot table Diego Excel Discussion (Misc queries) 2 January 31st 07 06:50 PM
Pivot table - Custom calculation question TaiwanSwede Excel Worksheet Functions 0 January 13th 06 04:52 AM
pivot table % calculation boris Excel Worksheet Functions 0 March 3rd 05 07:40 PM


All times are GMT +1. The time now is 08:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"