Hoping someone can give me a start. Difficult to explain so have attached an image.
Have a list of ITEMS. Also have a table of TESTED ITEMS. Need to create a PT to report number of items tested vs items not tested. Want to have a date slicer to select the year.
The data is in Access and I want to use Excel 2016 Data Model (but I think this does not determine the overall approach)
How to start please?
excel pivot report.png
Bookmarks