For years, my reflex for any quick breakdown was the same. I'd insert a pivot table, drag fields into the right boxes, then refresh it whenever the numbers changed. It worked, but required more ...
For years, pivot tables have been my go-to for almost every data summary task in Excel. Over time, I got pretty good at them, field lists, value settings, the whole ritual, but they never quite felt ...