This isn't earth shattering, but it still ticks me off...
Why can't I set the default settings for fields in the data portion of a pivot table? They always revert to "Count", even though that's hardly ever what I want to do ("Sum" works over 90% of the time).
It's just annoying when I'm building a table with 20 columns in it, and every time, I have to drop in the data field, then double click, change from Count to Sum, click off, and then repeat the whole process.
I've gone through everything I can think of Tools-Options and in the Pivot Table wizard. Am I missing something?
Why can't I set the default settings for fields in the data portion of a pivot table? They always revert to "Count", even though that's hardly ever what I want to do ("Sum" works over 90% of the time).
It's just annoying when I'm building a table with 20 columns in it, and every time, I have to drop in the data field, then double click, change from Count to Sum, click off, and then repeat the whole process.
I've gone through everything I can think of Tools-Options and in the Pivot Table wizard. Am I missing something?