How to hide/remove row from the straight table, such as illustrated in attached screenshot.
If SKU is your dimension then you can write something like this:
If(Makeup <> 'Set', SKU)
and then change the Label to SKU
If there is another way you want to hide then use that condition in the dimension.
The value is coming correct in Makeup = Set and I'm adding the value of Set in some other expressions.
But here only, I want to hide entire row of Makeup = Set.
I'm not going to disturb any expression where the value of Set is used.