Dear all,

How can I set a crosstab summerized field with both string and numeric data type? Because this field have both numeric and string value, I need to show numeric type for numeric value and string type for string value, so that when exported to excel the numeric field can be selected by mouse and see the SUM at the right bottom of the excel (If all are set to string type excel will not SUM these values).

Thanks.