Not Monitored
Tag not monitored by Microsoft.
40,940 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi, I'm new to power pivot. I am trying to import two data sources from excel files. One is a list of inventory with unique chart IDs. The second is a list of actual chartIDs billed with rate and invoice#. The purpose is to easily determine what in the inventory has NOT been billed yet.
So far I can pivot but only on what has been billed and is in both tables. I want to see the exceptions that are in one table and not the other.
I set up chart ID in both tables as the relationship.
Can you walk me through how I can do that? I appreciate it.