Skip to Content
avatar image
Former Member

Conditional Formatting to Hide a Row

I have been searching for a way to hide rows within a Webi report based on a couple of different criteria. Everything I found pointed to using conditional formatting to first white out the text and then to shrink the row. I have figured out how to white out the text but I am not finding a way to shrink the row height. How would one go about doing this?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 24, 2017 at 03:52 PM

    or you can create variable with if-else condition and apply filter to exclude the row.

    e.g show/Hide=if(object="A") then "Show" else "Hide"

    Apply filter on Show/Hide where equal to Show

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 24, 2017 at 07:47 PM

    You my want to create a new column with a value of 0 (false) or 1(true) based on your different criteria. Use this column of value 0 or 1 to hide or show rows.

    Hope this technique helps! You may explore this option in different ways, like the one mentioned above or also by using zero suppression options within WebI.

    Add comment
    10|10000 characters needed characters exceeded