Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 19 Oracle Analytics Lounge
- 222 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 83 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
How to create a condition based column in Column selector in OTBI Report?

User_P6HYL
Rank 1 - Community Starter
We are creating an OTBI report in which we want to use column selector .
Inside that column selector, we are trying to add the condition based column but we are unable to do that, even not able to write the formula/function inside that.
Is it possible to do that in column selector.
If so, could someone guide me through the steps or provide an example?
Thank you for your assistance!
0
Answers
-
Hi @User_P6HYL,
Try the below:- Create Condition-Based Columns First
Go to your OTBI analysis.
Add a column from the subject area.
Click the gear icon next to the column → Edit Formula.
Write your condition-based logic using SQL expressions like:
Save the column with a meaningful name.
sql
CASE WHEN "Employee"."Department" = 'Sales' THEN 'Sales Group'
WHEN "Employee"."Department" = 'HR' THEN 'HR Group'
ELSE 'Other'
END - Add Column Selector View:
In the Criteria tab, add all the columns you want to toggle between—including your newly created condition-based column.
Go to the Results tab.
Click New View → Column Selector.
In the Column Selector configuration, choose the columns you want users to switch between. - Use in Table or Graph View
Make sure the Column Selector is linked to a Table View or Graph View that uses the selected column dynamically.
You can check the below for more details:
Create a column and view selector in a Fusion OTBI report
Thanks,
Riyaz Ali0 - Create Condition-Based Columns First