Hello,

I'm trying to create a sheet in an excel document that compares data between two separate tables (A raw-data table copy-pasted from our reporting software, and a master-part-list) in order to display which parts have a report entry for a given day of the month, and which were missed and didn't get reported on for a given day of the month. Optimally, this would be displayed with the dates on top (column headers) and the part numbers from the master list on the left (row headers) with the intersections reading something like "Pass" or "Fail" or even better applying a number value that shows how many times on that day that the part was reported.

The issue i'm running into is that I can't figure out how to get the pivot table to understand the data in a way where it displays like this. What it wants to do instead is count the total number of part report entries, not based on their individual part #'s but rather counting ALL reports, and then apply those down the entire column for that date.

So it shows:
Day 1 Day 2
Part# 1: 99 Part# 1: 102
Part# 2: 99 Part# 2: 102
Part# 3: 99 Part# 3: 102

- Instead of doing what I want it to do and counting each part# entry based on part#. I have limited experience with pivot tables, we just recently updated from Office 2007 to Office 2023 so i'm trying to make use of the capabilities, i'm just stuck.

Any help would be appreciated, thank you.