I work in data analysis and use pivot tables every day. They are great, but for ONE feature; "Summarize Values By" cannot be applied to all values. So you have to right click, find the menu, and select "SUM" or "GROUP" or whatever for each column in Values.
There should be an option to set everything in "Values" to the same summarization. If there is already an option to do this then please, I will give you my money for it.
Noytal16 karma
I work in data analysis and use pivot tables every day. They are great, but for ONE feature; "Summarize Values By" cannot be applied to all values. So you have to right click, find the menu, and select "SUM" or "GROUP" or whatever for each column in Values.
There should be an option to set everything in "Values" to the same summarization. If there is already an option to do this then please, I will give you my money for it.
View HistoryShare Link