I have a report that shows me what documents have been sent to a list of people. At times, some people get missed or have not been sent the latest version of that document. What I want to be able to do is quickly see who (from the list of people who last received the docs) have not been sent the updated version.
To simplify it:
Person A and B are sent docs.
Person A is sent the docs.
I want to see a list with person B's name. It can be a new page, separate table, doesn't really matter at this point.
In the screenshots below, you can see when I click on the one document, it lists 2 people (earlier version). When I click on the second record of the document, it lists 1 person.In the second example, Justin did not receive the docs yet. I would like to be able to show who isn't listed as most times there are a large group of people being sent docs and scrolling through a list back and forth and doing an "eye test" will not be very reliable.
The names do not need to be highlighted. Creating a slicer of the names can work for individual users but in some cases there are a large amount of users that we need to go through. Checking one at a time would take a lot of time. Our aim is to be able to get the results, export them to Excel and pass them off to other people who need the information.