+ Reply to Thread
Results 1 to 4 of 4

How to create a Calculated Field based off two Avg fields in a Pivot table?

  1. #1
    Registered User
    Join Date
    05-14-2013
    Location
    NY
    MS-Off Ver
    Excel 2010
    Posts
    32

    How to create a Calculated Field based off two Avg fields in a Pivot table?

    Hello,
    I am having trouble to do the following.
    I have a Pivot table that pulls the Avg of two fields for two months, see example below.

    Avg Gross $ Avg Net $
    Jan 2014 20 10
    Feb 2014 30 20


    sample 1.png
    See sample attached.

    The Avg Gross and Net is shown by going into the values and selecting "Summarized value by -> Average".

    On the right side of this Pivot, what I wanted to do is to show a Avg Gross to Net $ in this pivot. So the formula should take "Avg Gross $" - "Avg Net $" = Avg Gross to Net $.

    I am having trouble calculting this new field in the pivot table using a calculated field because the Calculated field pulls the variables from the existing field list and there isn't a field called "Avg Gross/Net"....I need to find a way to calculate the Avg Gross to Net into the Pivot table so I can pull a pivot graph out of it.

    I hope this makes sense. I hope someone can help!!!

    Thank you!!
    Last edited by rcocalm; 02-12-2014 at 01:59 PM.

  2. #2
    Registered User
    Join Date
    06-09-2012
    Location
    India
    MS-Off Ver
    Excel 2007, 2010, 2013
    Posts
    26

    Re: How to create a Calculated Field based off two Avg fields in a Pivot table?

    Hi,

    I have attached a sample file showing how you can get the desired result.

    Let me know if its not clear.

    Regards
    Asar
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    05-14-2013
    Location
    NY
    MS-Off Ver
    Excel 2010
    Posts
    32

    Re: How to create a Calculated Field based off two Avg fields in a Pivot table?

    Hi there thank you for your response. Your example did not work but close. through your example, i was able to figure it out. All i really needed is add a column in the data itself to caclulate the difference between gross and net. And then in the pivot table, I can pull in the new column and run an average of that figure. Bingo!
    Thank you!

  4. #4
    Registered User
    Join Date
    06-09-2012
    Location
    India
    MS-Off Ver
    Excel 2007, 2010, 2013
    Posts
    26

    Re: How to create a Calculated Field based off two Avg fields in a Pivot table?

    Awesome!! glad I could at least help, if not solve your prob entirely.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 11-01-2013, 11:45 AM
  2. Replies: 1
    Last Post: 12-10-2012, 05:41 AM
  3. Replies: 0
    Last Post: 06-26-2012, 09:06 PM
  4. [SOLVED] Calculated Field in Pivot Table Based on Two Counted Fields
    By cmlits in forum Excel General
    Replies: 1
    Last Post: 03-30-2006, 12:50 AM
  5. [SOLVED] create calculated field in pivot table
    By kkerig in forum Excel General
    Replies: 2
    Last Post: 06-19-2005, 12:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1