Skip to Content
0

How to hide a column based on Prompt Values

Apr 21, 2017 at 05:46 AM

36

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Kuldeep Ghosh 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
10 |10000 characters needed characters left characters exceeded