Multiple tables lookup with multiple column filters by value
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