Forum Discussion
Splicer, multiple fields remove blanks
Hi there, I have a collumn for that lists the College a row is for:
However, the College of Science is split into further streams in another collumn:
The row values which are not within college of science are null.
Using this information I want to create a splicer, with a dropdown to select the different streams of College of science.
My question is, is there a way of remove the (Blank) value within the colleges that are not College of Science?
Thanks
Read about ISINSCOPE()
Note: There are hierarchy slicer visuals available that do that "automatically".
Note2: There is no magic to this. Expect bad performance especially when your cardinality is higher than a couple dozens.
1 Reply
- lbendlinSuper User
Read about ISINSCOPE()
Note: There are hierarchy slicer visuals available that do that "automatically".
Note2: There is no magic to this. Expect bad performance especially when your cardinality is higher than a couple dozens.