Forum Discussion
Solved
How do I hide a line that doesn't have values?
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.
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!
2 Replies
- VijayP
Community Champion
marcelojunior88 Try using IF(HASONEVALUE(COLUMNNAME),measure) to get the result required
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!
