Allow columns to be un-nested in pivot tables
I use pivot tables extensively for reporting but sometimes I need to report different metrics side by side. For example, count of one column next to row percentage total of another column. It would make life so very much easier if I were able to report different columns next to each other (un-nested), and would make Excel and pivot tables much more competitive as a reporting tool!
(I report on hundreds of entities at once, countif functions are cumbersome and spotty, I risk dropping rows by running successive pivot tables - and my rows are nested so "Show items with no data" is horrifying).