Forum Discussion

marcelojunior88's avatar
marcelojunior88
Regular Visitor
2 years ago
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 th...
Need Help
  • marcelojunior88's avatar
    marcelojunior88
    2 years ago

    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's avatar
VijayP
Icon for Community Champion rankCommunity Champion
2 years ago

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