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
Bookmarks