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

Vertical axis splitin a cross table based on a specific filed valuein one of thecolumns


Recommended Posts

Hi, this should be simple, I think... How do you add a vertical axis splitto a cross table based on a specific filed valuein one of thecolumns

I have theunderlying table:

ColA ColB ColC

A1 B1 val1

A1 B2val2

A2 B1 val3

A2 B2val4

A3B1 val1

A3B2val5

 

On which I make a cross table:

Horizontal axis = [Col B]

 

B1 B2

 

A1 val1 val2

A2val3val4

A3val1 val5

 

Vertical Axis = [ColA]

Values = UniqueConcatenate[Col C]

 

I'd like to further split the vertical axis by colB but only for specific colB fileds, e.g.[colB] = B1, i.e. ignoring any other Bs.

Is something like that possible

Many thanks

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...