I am trying to hide rows conditionally in a WEBI report v4.1. The highlighted row below is a sample of what I need to hide. If structure row is 'Estimated Savings' and measures are blank/0, then hide the row. My variable is the column on the right and displays Hide so seems to be working.
But the measure results display UNAVAILABLE when adding a filter to the table using my HideRow variable.
I have researched the forums and found 1 similar issue but gives no solution.