Conditional Formatting to Hide a Row

[Former Member]

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?

[amitrathi239 · Accepted solution]

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

[Former Member · Accepted solution]

Doesn't a filter like that actually filter out the data from the totals? I want to hide the rows due to certain criteria but they should still be included in the totals.

[amitrathi239 · Accepted solution]

If you still want to add in the total then use nofilter() function in total to add the amount.

[Former Member · Accepted solution]

This may be the answer I was looking for. I will test it and find out.

[Former Member · Accepted solution]

Yep, this worked. I will mark it as the solution.

[Former Member]

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.