Prompt based report column

Question

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

[Deleted User] · Answer

What Gianni said or have you already looked at the out-of-the-box column selector?

Gianni Ceresa · Answer

Sure, CASE WHEN THEN your-column-A WHEN THEN your-column-B END. Just use a presentation variable you set in your dashboard prompt for the condition.