G Guest Aug 2, 2007 #1 Is there a way to change the default in the field settings or change multiple lines at once from "count" to "sum"? Thanks, Cindy
Is there a way to change the default in the field settings or change multiple lines at once from "count" to "sum"? Thanks, Cindy
R Roger Govier Aug 2, 2007 #3 Hi Cindy Jim is quite right, there is no inbuilt feature to do this. But, Debra Dalgleish has a nice add-in on her site which allows you to do many things with the Pivot Table, including changing all data fields to the selected summary function. http://www.contextures.com/xlPivotAddIn.html
Hi Cindy Jim is quite right, there is no inbuilt feature to do this. But, Debra Dalgleish has a nice add-in on her site which allows you to do many things with the Pivot Table, including changing all data fields to the selected summary function. http://www.contextures.com/xlPivotAddIn.html
