+ Reply to Thread
Results 1 to 8 of 8

Adding additional columns inside a pivot table to calculate rates from pivot table

  1. #1
    Registered User
    Join Date
    11-23-2011
    Location
    Los Angeles
    MS-Off Ver
    Excel 2003
    Posts
    19

    Adding additional columns inside a pivot table to calculate rates from pivot table

    Hi Everyone,

    Does anyone know how to calculate a rate (num/denom) based on two specific columns within a pivot table? I tried using the "calculated field" but it is referencing columns from my original dataset when I want to reference data specifically from the pivot table I generated. Thanks for your help!

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Adding additional columns inside a pivot table to calculate rates from pivot table

    Hi,

    Can you provide an example of what it is you want to do? Since any data in your pivot table must come from the source data, it may be possible to find a solution- although if you are actually using 2003 you are limited to calculated fields if you want the solution inside the pivot table, rather than as formulas adjacent to it.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Registered User
    Join Date
    11-23-2011
    Location
    Los Angeles
    MS-Off Ver
    Excel 2003
    Posts
    19

    Re: Adding additional columns inside a pivot table to calculate rates from pivot table

    sample.png

    Sure. I want to take all the "Yes total" rows and divide them with the "grand total" rows by creating a new column called "screening rate"

  4. #4
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Adding additional columns inside a pivot table to calculate rates from pivot table

    And are you in fact using 2003? If you are, you will need formulas outside the pivot table.

  5. #5
    Registered User
    Join Date
    11-23-2011
    Location
    Los Angeles
    MS-Off Ver
    Excel 2003
    Posts
    19

    Re: Adding additional columns inside a pivot table to calculate rates from pivot table

    No, I am using excel 2016

  6. #6
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Adding additional columns inside a pivot table to calculate rates from pivot table

    Do you have Power Pivot available?

  7. #7
    Registered User
    Join Date
    11-23-2011
    Location
    Los Angeles
    MS-Off Ver
    Excel 2003
    Posts
    19

    Re: Adding additional columns inside a pivot table to calculate rates from pivot table

    Yes i do, I'm only vaguely familiar with it. How do I load this pivot table onto powerpivot? Thanks for all your help.

  8. #8
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Adding additional columns inside a pivot table to calculate rates from pivot table

    You can link the table to the data model on the Power Pivot tab.

    You can then either create a measure for the count values and then a similar measure which calculates that measure but for all the column values, or simply add the counter again and show it as a percentage of the row total. I cannot really be more specific without a sample workbook.

+ 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: 1
    Last Post: 08-14-2014, 10:37 AM
  2. [SOLVED] Adding columns to pivot table
    By sur4j in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 03-11-2014, 07:42 PM
  3. Adding more than 255 columns to Pivot table
    By ReplicaR in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-30-2012, 03:00 PM
  4. Pivot Table adding additional columns excel 2007
    By runner in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-28-2012, 12:24 PM
  5. Adding additional colums in the pivot table
    By Excel Dumbo in forum Excel General
    Replies: 7
    Last Post: 08-21-2012, 04:00 AM
  6. [SOLVED] Adding together only some of the columns in a pivot table
    By Waynedalf in forum Excel General
    Replies: 4
    Last Post: 06-06-2012, 10:23 AM
  7. [SOLVED] How do I link a cell outside a pivot table to one inside the table
    By GPGTDRVR in forum Excel General
    Replies: 3
    Last Post: 08-16-2006, 09:50 PM

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