Hi,
I have a requirement that we have to hide a column in webi report based on Prompt values.
Ex:
I have columns like
Vessel Name Week1 Week2 Week3
Optional Prompts Week1, Week2, Week3
If we pass Week1 prompt value then report should display Vessel Name Week1
If we pass Week2 prompt value then report should display Vessel Name Week2 like wise.
Can you please suggest with solution.
Note: Hiding blocks based on condition will not work.
Week1,Week2 and Week3 are measures
Try something like:
=if(IsPromptAnswere d("Week1")=1) then [Week1] else ""
=if(IsPromptAnswere d("Week2")=1) then [Week2] else ""
=if(IsPromptAnswere d("Week3")=1) then [Week3] else ""
In format table just un-select the option for "Show col with empty measure values". See if this helps.