Forum Discussion
Remove blank rows in an array
Hi Anonymous
Can you share a screenshot of the filter you applied? If you filtered on non-blank, I don't see how it would exclude these other rows.
Hello @TaylorN ,
Attach the image below.
He removes them because I have a fact board like this:
SkCuenta Company Must have
1 5 100 0
1 6 50 0
And my dimension table, with which I'm doing the levels in the matrix is like this:
SkCuenta Nivel1 Nivel2 Nivel3 Nivel4 Nivel5 Nivel6
5 1 13 1305 13050 13050505 (Level 6 blank)
If I don't see level 6, the fact table line with the skAccount-5 is as if it is not binding.
A greeting
Hola Anonymous!
Apologies, I think I misunderstood. That does make sense because the whole row would be excluded if the value is blank.
I don't know of a way to remove the blank rows (perhaps someone else does?), but you could transform the blank values into something like "No Level 6", "N/A", or perhaps even use the Level 5 value if the Level 6 is blank? I am sure the users will understand, but this is the problem with ragged hierarchies.
Hello! Good morning!
I have the same problem! Have you found a solution for it?
Thank you!
Joseph.
