+ Reply to Thread
Results 1 to 3 of 3

One list, two production line, one pivot table?

  1. #1
    Forum Contributor
    Join Date
    01-29-2019
    Location
    Drenthe, Netherlands
    MS-Off Ver
    Dutch Office 2019
    Posts
    291

    One list, two production line, one pivot table?

    How to get from one list with two production lines all the date organised in one pivot table.
    This is a growing list en if it is possible hold at the end 2 years of data!!

    I made a example. Maybe there is a better way to organise the data. Maybe this is not possible, but i don't get it.
    Can someone help me out?
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,176

    Re: One list, two production line, one pivot table?

    store data as:

    Date Order Production in kg Quality Line
    6/10/2021 6:00 33 322 1 Line 1
    6/10/2021 6:00 32 311 3 Line 2
    6/10/2021 7:00 33 311 1 Line 1
    6/10/2021 7:00 32 366 3 Line 2


    then you can pivot

  3. #3
    Forum Contributor
    Join Date
    01-29-2019
    Location
    Drenthe, Netherlands
    MS-Off Ver
    Dutch Office 2019
    Posts
    291

    Re: One list, two production line, one pivot table?

    De kg/h is a trending value from a other program.
    This program writes the values: time and kg/h every our for both lines in excel vertical or horizontal (optional). The quality we ad. And so we have is all in 2 lists. I have to do something with the kg/h per line!

+ 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. [SOLVED] Calculate monthly production needs based on aggregate production table
    By aroseb in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-24-2020, 12:29 PM
  2. Replies: 1
    Last Post: 10-10-2016, 01:17 PM
  3. Data capture from a production line
    By Stuartra in forum Excel General
    Replies: 1
    Last Post: 06-23-2016, 05:22 AM
  4. Data capture from a production line
    By Stuartra in forum Excel General
    Replies: 6
    Last Post: 06-22-2016, 02:41 PM
  5. Analyze production, if produced last year, in pivot-table
    By Simonius in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-27-2015, 09:56 AM
  6. Production Line Calculation
    By ows246 in forum Excel General
    Replies: 15
    Last Post: 01-08-2013, 04:45 AM
  7. production assembly line
    By rrlan77 in forum Excel General
    Replies: 0
    Last Post: 07-01-2012, 11:15 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