+ Reply to Thread
Results 1 to 6 of 6

Pivot Table - Calculating Percentage between 2 counted fields

  1. #1
    Registered User
    Join Date
    06-21-2010
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007
    Posts
    3

    Question Pivot Table - Calculating Percentage between 2 counted fields

    I have a data set that includes four columns; batch #, type, suit date and judgment date.

    When creating a pivot table i have the batch # and type under row table and type under value to give me a count of each type by batch #. I add suit date to the values to get a count of suits of how many suits by type by batch #. I'd like to see the percentage between the two (count of type/count of suit date). How do i do that? I figure I need to create a calculated field, but don't know how it should be set up.

    Any help?
    Thanks

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Pivot Table - Calculating Percentage between 2 counted fields

    Hi Niq6,

    It would be better in understanding if you could upload a sample workbook to explain your query.. thanks.


    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Registered User
    Join Date
    06-21-2010
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Pivot Table - Calculating Percentage between 2 counted fields

    Here you go. I need a field that will give me "count of suit_date"/"count of triple_match" as a percentage.
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Pivot Table - Calculating Percentage between 2 counted fields

    You mean (something) like this?
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    06-21-2010
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Pivot Table - Calculating Percentage between 2 counted fields

    Almost oeldere. You just showed the percentage of suits that were there. i need the whole count of triple_match divided by the total count of suit_date. so for 231, its 2/5 or 40%. 231-ctn would be 50% and 231-cty would be 33%.

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Pivot Table - Calculating Percentage between 2 counted fields

    I see your point.

    Unfortenally i can't help you enough with your problem.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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