Hi All,
I need your help as ive been going round in circles for the last few hours working out how to combine two reports into one and im stuck needing your expert help.
I have tried all sorts of ways but none have worked.
The problem….
One report shows the product number and how many units we have sold:
Product Sold
2000102 1
2000162 5
2000328 6
2000407 7
2000622 10
The other report shows the product codes we have brought:
Product Purchased
2000102 5
2000162 4
2000329 6
2000400 2
2000622 3
What I need is a report which would show me a list of all the products from both reports, the next to them how many were sold and how many were brought. From the examples given above you can see there are different products sold and purchased. What I want is a formula that lists all products that are unique and then lists the number sold and purchased, if not information is listed I need it to record it as zero.
The above would look like this:
Product Sold Purchased
2000102 1 5
2000162 5 4
2000328 6 0
2000329 0 6
2000400 0 2
2000407 7 0
2000622 10 3
Hope some one can help, ive pulled all my hair out already!
Paul
Bookmarks