Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Can we add a filter where we can compare one Column with other 'Calculated Column'

15
Views
0
Comments

Summary

Filter Based on Calculated Column

Content

Hi Experts,

I have a OTBI Report where I am fetching the Person Details along with who columns.

Also I am having a calulated column which return the MIN(LAST_UPDATE_DATE)

Can i have a filter such that LAST_UPDATE_DATE > = MIN(LAST_UPDATE_DATE)

As a second step we would like to know can we replace MIN(LAST_UPDATE_DATE) with some bind variable

Thanks

Ashish