How do I hide a line that doesn't have values?

[marcelojunior88]

I'm making an array that has 3 levels of rows. These levels come from three different dimension tables. I would like that when level 2 has no information (blank line), it does not show it, but yes the next level that is not blank. I've put an example below.

[marcelojunior88 · Accepted solution]

Hello, the solution didn't work , but I was able to get around it by filling in the null values of hierarchy two, with the values of hierarchy three.
Thanks!

[VijayP]

@marcelojunior88  Try using IF(HASONEVALUE(COLUMNNAME),measure) to get the result required