Categories
- All Categories
- Oracle Analytics Learning Hub
- 20 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 233 Oracle Analytics News
- 45 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 87 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
Prompt based report column
mmajdana1
Rank 6 - Analytics & AI Lead
Hi , I am using OBIEE 12.2.1.2.0
I would like to know if there is a way where I can show a different column in a pivot table based on my prompt selection.
Kr, Matija
0
Answers
-
Sure, CASE WHEN <condition> THEN your-column-A WHEN <condition> THEN your-column-B END.
Just use a presentation variable you set in your dashboard prompt for the condition.
0 -
What Gianni said or have you already looked at the out-of-the-box column selector?
0
