+ Reply to Thread
Results 1 to 2 of 2

Pivot Table Percentage Error

  1. #1
    Forum Contributor
    Join Date
    02-23-2014
    Location
    Melbourne
    MS-Off Ver
    Microsoft 365
    Posts
    174

    Pivot Table Percentage Error

    Hello Experts
    I have created an excel file to check the status of jobs shipped date vs lead time
    I thought it was working, till I put only two rows of data, One Early than lead time and one late.
    But when I refreshed it. Instead of both rows showing as 50% each, it shows 33.33% and 66.67%

    What am I doing wrong?
    I have attached my file and screen shot

    Thanks
    Rahul
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    459

    Re: Pivot Table Percentage Error

    I added a duplicate Count of S/O and changed to % of total.
    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 table and percentage of row
    By qaiztan in forum Excel General
    Replies: 3
    Last Post: 05-05-2017, 09:53 AM
  2. Replies: 2
    Last Post: 06-09-2014, 02:03 PM
  3. [SOLVED] Pivot Table Grand Total Percentage Error
    By rosehill in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-12-2013, 10:01 AM
  4. Percentage in pivot table
    By Merijn in forum Excel General
    Replies: 4
    Last Post: 05-10-2012, 08:37 AM
  5. Excel 2007 : pivot table percentage
    By mubeenff in forum Excel General
    Replies: 0
    Last Post: 03-28-2012, 03:00 AM
  6. Percentage in a Pivot Table
    By rmikulas in forum Excel General
    Replies: 3
    Last Post: 10-13-2010, 03:59 PM
  7. Percentage in a Pivot table
    By jomili in forum Excel General
    Replies: 3
    Last Post: 06-21-2010, 03:31 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