Everyone knows how to build a Pivot Table, but very few know the insane tricks that can make them 10x more powerful. In this blog, I’ll show you how to push Pivot Tables beyond their regular limits and solve problems you thought needed manual workarounds. You’ll learn how to do double summarisation (Pivot on top of Pivot), find the top salesperson’s sales and name in a single formula, reshuffle Pivot Table items manually, selectively repeat labels and even create multiple Pivot Table reports on separate sheets in one click. These are the kind of tricks that make people stop and ask, “Wait, how did you do that?”
