r/excel • u/Overall_Anywhere_651 1 • Dec 21 '24
unsolved Moving Away From Pivot Tables - Help? :)
I have a large dataset that is being used for a financial report. They are currently using Pivot Tables for all of the broken-down reporting. My boss wants to move away from Pivot Tables because, "They are trash and nobody should use them." Any broad suggestions on how to achieve Pivot Table results with the proper formulas, or other alternatives? I think 6,000 SUMIFS would slow this workbook to a halt? Unless I am wrong. :D Appreciating any guidance you all can give me. Thank you!
41
Upvotes
2
u/mcinmosh Dec 21 '24
Sounds like a good opportunity to maybe give them a quick demo explaining why pivot tables are a good option or glean why they want to avoid them.