Column hiding in webi

[Former Member]

Hi,

I have a requirement where in i need to hide the columns in WebI based on the prompt selection.

For Eg: A sales report has three measures M1,M2,M3.There is a multi select prompt called measure type
Which has M1,M2,M3 as its List values.Based on the values selected in the prompt
the report should display corresponding measures.
Please note that users can select either all the Measures or the measures of their choice.

Would appreciate any response..

Thanks in Advance,
Vivek

[Former Member]

Hi,

you could also use the same priniple as explained in following blog:

http://blog.davidg.com.au/2012/07/toggle-display-of-text-and-key-in-webi.html

Plus you need to user UserResponse function in order to get the response from the prompt.

BR

[Former Member]

Hi Vivek,

If the measures are limited, you can shift the variables and hide the last columns using alerters.

For Eg: If the user select M1 and M3, use the if condition to display the M1 in first column and M3 in the 2nd column, user the alterers to hide the last column(make the column formatting to match the background).

This will not give any blank column inbetween.

Hope this helps.

Thank You.

Harini