Hi all (again)
One last question on pivot tables. Why when adding a column label to a pivot table it will default to a sum of the data and other times a count of the data? I have noted these differences when one set of data is text and the other is numeric and that makes sense. However there are times when both sets of data are numeric but the pivot table will count one list and sum the other. I sorry this is one of the other annoying things that drive us all crazy.
Chris
One last question on pivot tables. Why when adding a column label to a pivot table it will default to a sum of the data and other times a count of the data? I have noted these differences when one set of data is text and the other is numeric and that makes sense. However there are times when both sets of data are numeric but the pivot table will count one list and sum the other. I sorry this is one of the other annoying things that drive us all crazy.
Chris