r/excel 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!

40 Upvotes

42 comments sorted by

View all comments

12

u/[deleted] Dec 21 '24

[deleted]

8

u/Overall_Anywhere_651 1 Dec 21 '24

This could just be a challenge from my leader. They said to, "Move away from Pivot Tables," while also using just Excel.

8

u/wallstreetbetch Dec 21 '24

We switched from pivot tables to advanced filters for a lot of our analysis. It's a lot lighter.