Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

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


David Gaspari

Recommended Posts

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...