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

Hierarchy Filter in Calculated Column

April Steele

Recommended Posts

I have a Hierarchy for date (Year, Quarter, and Month) in a text box filter so viewers can select certain months they want to see. Is there a way to use this filter in a calculated column


Date Column - Procedure Date

Hierarchy Calculated Column - Date Hierarchy

Column 1 - Is my Numerator column

Column 2 Is my Denominator column

What I want is to create a new calculated column:

Sum(column 1)/sum(Column 2) based on what Date Hierarchy (months/year/quarters) are selected in the text box filter

Link to comment
Share on other sites

Could you work with a drop down (document property) that holds year/quarter/month (=0,1,2 in the hierarchy)


If yes, then you could use this document property in your calculated column and in your hierarchy.


If you could post some dummy data set here it would be helpful to understand your situation.

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