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

Group bottom X rows in cross table with multiple columns.


Ryan James 3

Recommended Posts

I have a cross table with several calculated columns and multiple rows.

I would like to group the bottom X rows as 'Other' but I can't seem to make it work.

I've managed to create a filter where if it's below X boepd or X $$ that it classifies as other, but I would prefer to dynamically show only the top 8 categories.

How can I do this I've tried dense rank a number of different ways, but it groups them incorrectly.

Thanks in advance for my help.

Here is my column formulas:

(case

WHEN (Sum([Oil (BOPD)]) / Sum([bOEPD]))>=${TypeOilPctOilCutoff} THEN Sum([bOEPD]) * ${TypeOilValue}

WHEN (Sum([Oil (BOPD)]) / Sum([bOEPD]))

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