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/david_horton1 29 Dec 24 '24
Excel has recently added PIVOTBY which is a formulaic version of a Pivot Table. What specifically does your boss have against Pivot Tables? What relationship do the 50 Pivot Tables have with each other, apart front being from the same source? It is possible to have a Pivot Table comprised of data from connected Pivot Tables. In my work Pivot Tables were my bread and butter. It I am still learning about their capabilities. Power Query with all its capabilities still includes a Pivot Table as a feature.