using Power Query and pivots slicers instead of SUMIFS()
Channel: Joe DiNoto
Date: 28/06/2023

I used tables, power query, and pivot slicers instead of SUMIFS(). Personal preference, but I have found tables to be more robust when it comes to maintaining your final pivots, you can add or delete from a table without it interfering with your formulas. 

Source SUMIFS() video from the CheatSheets channel:
https://www.youtube.com/watch?v=FR1XHh2Eh2g
https://www.instagram.com/reel/Ct9FmrVtS2T
https://www.tiktok.com/@cheatsheets/video/7248607793580625194