How Does a Massively Competent Org Like M$ Overlook Fruit Like This?

Manually group data, you get the buttons that let you expand and collapse all :

Build a pivot table and.... wouldn't it be nice to have the same thing? Idiots!

And how about the number formatting? If you go to your data and format revenue as currency, wouldn't you like that format to be reflected in your pivot? *ds!