Using charecter fields as values in WRS crosstab

[jaxenro]

whenever i use a charecter field as a value and try to use it in a crosstab i get this "cannot be included in a crosstabulation table because the aggregation type(s) are not supported" yet i set it to "MAX" which i thought was a supported aggregate type. is there a trick to making this work?

[mojerry2]

I suppose you've found a solution but if it's a character field containing numbers you can create a new field in your information map and put your expression.

input(column_name,$8.)