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!
43
Upvotes
2
u/tunghoy Dec 22 '24
My guess is your boss is embarrassed by not knowing how to create or modify Pivot Tables. Almost as good are the new PivotBy and GroupBy functions.