Skip to Content

How to hide a column based on Prompt Values

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 21, 2017 at 08:34 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded