Forum Discussion
How can I get data from 2 separate sets with 2 separate pivot tables to have 1 slicer?
Hello. I have data from Nice and Cisco that I need to combine into a usable report for leadership to use for their agents. Currently in my org the two systems do not talk to one another, which i...
You may create another table with unique agent names (with Power Query), add all 3 tables to data model, create relationships of source tables with agents one, build PivotTables from data model (adding agents from 3rd table) and slicing on agents.