Default field setting for cross tabs

[Bob Dobalina]

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

 

[Dave Peterson]

If there's any non-numeric cells in that column (including text and empty
cells), then you'll get Count. If it's all numeric, then you'll get Sum.

I don't know think there's a way to change that behavior.