Can a filter be applied to a result column?

Question

I created a union between two subject areas and performed some calculations as part of one of the result columns. I would now like to filter based on the output of the result column, to only see rows where the value is greater than 20%. Adding a filter to a result column is not an option. Is there a workaround? Do I have to create a second analysis?

ca$hmon3y · Answer

https://community.oracle.com/tech/apps-infra/discussion/comment/16775038#Comment_16775038

Sorry for being generic, I don't know how to describe the table well without providing sensitive information. The Selection Steps option is greyed out, so I can't perform any steps. I'm not sure if that's due to the fact that it's a union of two subject areas or due to the nature of the columns.

[Deleted User] · Answer

You're not providing any detailed information, so generic answer:

Have you looked at using selection steps?