I'm trying to create multiple filters on one dataset. Right now I'm following the below procedure but is there anyway I can cut this short?
1) Filter 1 - Remove zeroes in column 'value'.
2) Filter 2 - Remove Nulls in column 'value'.
3) Filter 3 - Remove records 'total' in column 'F1'.
3) Filter 4 - Remove records 'total' in column 'Name'.
Solved! Go to Solution.
Yes it can with OR operator, using a single filter tool.
!(Value = 0 OR IsNull(Value) OR Contains([F1], "Total") OR Contains ([Name], "Total"))
Cheers,
Thanks Thableaus, that helped!
Cheers