When you need to hide fields through various conditions within the Grid, we can do it through a query.
The first thing we are going to do is a query and we will store it inside a variable.
Then we use the macro sc_lookup.
After using said macro, we proceed to store it in an array, since within a Grid it is not possible to directly reference the field to make comparisons.
So in this example we are going to be using the macro sc_field_display which is the one that allows to show or hide a said field based on a condition.
Next the example: