Carrie laments:
Is there a way to change the default in a pivot table so sums the values when created rather than count? It is very time consuming if you have several data points.
I hear ya, sister. Excel does a pretty good job guessing, but sometimes it gets stuck on Count like that’s all [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2010/08/03/toggle-pivotfields-from-count-to-sum/
Posted
Aug 03 2010, 07:30 AM
by
Daily Dose of Excel