Skip to Content
avatar image
shiva kumar

How to hide a column based on Prompt Values

Apr 21, 2017 at 05:46 AM | 40 Views | Last edit Apr 21, 2017 at 05:54 AM 2 rev.

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

SAP BusinessObjects - Web Intelligence (WebI)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Kuldeep Ghosh
    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