View Single Post
  #1   Report Post  
Marcus Ahlbäck
 
Posts: n/a
Default Why does my Excel pivottable uses count instead of sum

When I create a pivottable from some imported data Excel (2003 SP2) sometimes
chooses to summarize the data by using the function "count" instead of "sum",
which I then have change manually. What is it in the database that is
triggering Excel to choose either function?