+ Reply to Thread
Results 1 to 2 of 2

Add Percentage of Columns in Pivot

  1. #1
    Forum Contributor
    Join Date
    05-07-2007
    Location
    Singapore
    MS-Off Ver
    2006/2016
    Posts
    170

    Add Percentage of Columns in Pivot

    Basically what I'm trying to do is to make the yellow column (which is currently made using a formula) part of the pivotable itself

    Thanks in advance for any help
    Attached Files Attached Files

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Add Percentage of Columns in Pivot

    You can add a calculated field which is ='Quantity Acceptance' /'IQC Rcv Qty' as in the attached.
    Attached Files Attached Files

+ 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. Pivot - Percentage to compare two subtitle columns
    By 125ml in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-11-2018, 06:01 AM
  2. [SOLVED] How to calculate percentage between two columns in pivot
    By sarat47 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-15-2016, 08:26 AM
  3. Replies: 4
    Last Post: 02-02-2016, 12:36 PM
  4. Compare Pivot Table Columns to show Percentage Change
    By PTables in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-29-2016, 02:52 AM
  5. Calculated Field to get Percentage of Two Columns in a Pivot Table
    By mbhc77 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-04-2013, 06:32 AM
  6. Problems with percentage totals in columns in pivot table report
    By Zyphon in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-13-2013, 10:50 AM
  7. Replies: 2
    Last Post: 04-14-2010, 05:26 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