Hi Friends - I'm having trouble solving this and would greatly appreciate your help:
I have two tables with many columns: using sample fake data for easiness. Table1 has project details, Table2 has approval detials. I want to get a count (with drilldown to see details) of projects that have all required approvals, projects with 1 missing approval, projects with 2 misisng approvals, projects with no approval.
Table1:
| Project | Name | Department |
| A | Name1 | Dep1 |
| B | Name2 | Dep2 |
| C | Name3 | Dep3 |
| D | Name4 | Dep1 |
Table2:
| Project | Signed By | Process |
| A | Tech | Implementation |
| A | Business | Implementation |
| A | Quality | Initiation |
| B | Tech | Implementation |
| B | Business | Initiation |
| B | Quality | Initiation |
| B | Tech | Initiation |
| B | Business | Initiation |
| B | Business | Close |
| C | Tech | Initiation |
| C | Business | Implementation |
So, looking to get something like this:
| Total Projects | Projects with 1 approval missing | Projects with 2 approvals missing | Projects with 3 approvals missing |
| # | | | |
with drilldown to see details and also add slicers for Department and other required columns. Please help
