View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bob Dobalina
 
Posts: n/a
Default Default field setting for cross tabs

Hi group,

I am trying to figure something out for a friend. He is coding in VB and
creating cross tabs. I'm not sure of the specifics, but when he pulls in a
new field into the cross tab the default field setting is always "Count".
However, it seems as if the field name begins with "TOTAL" it defaults to
"Sum". Is that true?

Is there a way to always set the default so that it is "Sum" instead of
"Count"?

Thanks!!
- S