I have a query (attached) that shows a part number and how many of that part # we shipped. I narrowed the query down to the last two years. I created a report (attached) and it is fine. But now I want to create a less detailed report that just shows each part #, # of shipments 2015, Total quantity shipped 2015 , # of shipments 2016, Total quantity shipped 2016
I am having trouble figuring out how to go about getting my report to look like this. Any help would be much appreciated!
Basically want it to look like this. I am using the first part # from the image of the report I attached.
Part # # of shipments 2015 Total quantity 2015 # of shipments 2016 Total quantity 2016
AC0201010000 9 405 7 581 Query.PNG query-2.PNG report.PNG