I have 4 tables with the same columns (sales, 4 different revenue accounts) and need to make 1 pivot table with the combined data but haven't had any luck. I have tried using the data model, power pivot, power query... Can anyone help me?? I can obviously combine all tables and make 1 pivot, but...