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:


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