How to hide a column based on Prompt Values

Question

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

Answer 1

Kuldeep Ghosh Answered Apr 21, 2017 at 08:34 AM

0

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.

Share

Comment

Find Questions & Answers