L Larryq22 Jul 17, 2009 #1 In Excel 2007, how do I set the calculation method in pivot tables so the default is "count" (rather than "sum," "average,", etc)?
In Excel 2007, how do I set the calculation method in pivot tables so the default is "count" (rather than "sum," "average,", etc)?
D Dave Peterson Jul 17, 2009 #2 You can't change the default. You'll end up with Sum if all the cells in that field are numeric (no empty cells, too!). You'll end up with Count if at least one cell is not numeric (empty or text). You may want to take a look at Debra Dalgleish's PivotPower Add-in: http://contextures.com/xlPivotAddIn02.html#PivotItems
You can't change the default. You'll end up with Sum if all the cells in that field are numeric (no empty cells, too!). You'll end up with Count if at least one cell is not numeric (empty or text). You may want to take a look at Debra Dalgleish's PivotPower Add-in: http://contextures.com/xlPivotAddIn02.html#PivotItems
L Larryq22 Jul 20, 2009 #3 Thanks Dave. Dave Peterson said: You can't change the default. You'll end up with Sum if all the cells in that field are numeric (no empty cells, too!). You'll end up with Count if at least one cell is not numeric (empty or text). You may want to take a look at Debra Dalgleish's PivotPower Add-in: http://contextures.com/xlPivotAddIn02.html#PivotItems Click to expand...
Thanks Dave. Dave Peterson said: You can't change the default. You'll end up with Sum if all the cells in that field are numeric (no empty cells, too!). You'll end up with Count if at least one cell is not numeric (empty or text). You may want to take a look at Debra Dalgleish's PivotPower Add-in: http://contextures.com/xlPivotAddIn02.html#PivotItems Click to expand...
