How to Group Columns in a Cross Table [Axis.Default.Names]

[David Gaspari]

I have a need to group the columns in a cross table. To help clarify the request, I created a trivial example and attached a picture. The example is a simple table with 3 columns of data. Then a cross table is created witha sum and max column for each of the columns in the data table. The request is to create agroup for all of the "sum" columns and a group all of the "max" columns; as shown in the picture. I tried to accomplish this withinthe axis expression, but it results in an error

0 then "SUM'S"

when Find('Max',[Axis.Default.Names])>0 then "MAX'S"

end

>

Error: Invalid type for function call 'Find'

Any ideas on how this might be accomplished