PC Review


Reply
Thread Tools Rate Thread

Calculated Field in Pivot Table

 
 
Jeff Reese
Guest
Posts: n/a
 
      10th Dec 2007
Hello.

I'm using Excel 2007.

I have a pivot table that returns the data below. Note that Failure Rate is
a calculated field based off of Failures and Uses

Failures Uses Failure Rate
Category A 5 10 50%
Category B 10 10 100%
Category C 15 20 75%
Grand Total 30 40 75%

My Question:
Is it possible to create another calculated field that divides Failures by
the Uses Grand Total. So, something like:


Failures Uses Failure Rate Failures/Total Uses
Category A 5 10 50% 12.5%
Category B 10 10 100% 25%
Category C 15 20 75% 37.5%
Grand Total 30 40 75% 75%

Here's the math for the new calculated field:
Category A: 5/40
Category B: 10/40
Category C: 15/40

The piece I'm not sure can be done is to reference the Uses Grand Total in a
calculated field somehow. What I have to do now is get the Pivot as far
along as I can then create formulas off to the side. I want them to be part
of the pivot.

Any help is appreciated.

Thanks,
Jeff

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I remove a Calculated Field from the Pivot Table field list TheTraveler Microsoft Excel Misc 2 9th Apr 2010 06:55 PM
Pivot table, IF function, calculated item versus calculated field NomadPurple Microsoft Excel Misc 1 9th Mar 2010 03:17 PM
Calculated Field and Calculated Item in Pivot Table Fred Smith Microsoft Excel Misc 0 4th Mar 2007 08:15 PM
Pivot Table Formulas Calculated Item / Calculated Field =?Utf-8?B?VmlrcmFtIERoZW1hcmU=?= Microsoft Excel Programming 2 10th Oct 2006 08:45 AM
pivot table formulas for calculated field or calculated item =?Utf-8?B?Vmlja3k=?= Microsoft Excel Misc 3 6th Jun 2006 05:06 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:44 PM.