Pivot Table Help
Pivot Table Help
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Pivot Table Help

  1. #1
    New Member
    Join Date
    Nov 2017
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Pivot Table Help

     
    Hey Guys,
    I have a data that currently looks something like this...
    WO Nbr Part Nbr SCP Orig WO Qty Qty Scrap
    10044 31593 PDB 408 22
    10044 31593 HMI 408 11

    Obviously there are a ton more row, scrap codes, etc. But how would I go about setting up a pivot table that gets me scrap %? Which would pretty much be the sum of qty scrap / orig wo qty (408). Everytime I try and add orig wo qty to values it counts it as 816 instead of the 408. Please help

  2. #2
    New Member
    Join Date
    Nov 2017
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot Table Help

      
    anyone?

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com