+ Reply to Thread
Results 1 to 4 of 4

Combining Pivot Tables/Charts?

  1. #1
    Registered User
    Join Date
    07-11-2019
    Location
    Centennial, CO
    MS-Off Ver
    Office 2016
    Posts
    2

    Combining Pivot Tables/Charts?

    I have a fairly simple data set that I want to analyze. You can think of it like inventory. In column B I have a product name. In column O I have a date that the product was received. In column M I have a date the product was sold. Each line item is a unique "product" so to speak. I want to count how many products were received on each date and be able to b/o it down by category and compare that to how many products were sold in a similar manner. The main problem is that I can easily do this in two separate pivot tables but I can't seem to figure out how to do it all in one pivot table so that I can create a pivot chart to look at the data. So I either need to combine the pivot tables or combine the pivot charts or very possibly find a different solution to my data problem. See example pictures. Thanks so much.

    This is a sample of the data. This sample set has 5 interim, lowpri products received on various dates in May and sold on July 1st.
    Capture1.PNG

    Two separate pivot tables showing the count of the received and sold/released products to give you an idea of what I want and what I have so far. So for example using a common date of July 2nd. On July 2nd we received 2 lowpri products and sold 59. I would like to see this in the same table if possibly but using the count function in the same table results in redundant results as it would simply count each item on each row resulting in the same number for both.
    Capture2.PNG
    Attached Images Attached Images
    Last edited by DRiBay; 07-12-2019 at 12:21 PM.

  2. #2
    Forum Moderator Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    8,622

    Re: Combining Pivot Tables/Charts?

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Registered User
    Join Date
    07-11-2019
    Location
    Centennial, CO
    MS-Off Ver
    Office 2016
    Posts
    2

    Re: Combining Pivot Tables/Charts?

    After thinking about it overnight I believe I solved my own problem. I was trying to use count to get unique counts for a data set that had one product with two dates. I separated the data and made it so that each line item only had one date and added a column for received and sold with "1" in the column if it was received or sold and then I was able to get my pivot chart to show me what I needed.

  4. #4
    Forum Moderator Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    8,622

    Re: Combining Pivot Tables/Charts?

    Thanks for sharing your solution

+ 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