omit record in the expression

[Anonymous]

Hi,

how do I omit a row from showing up in my grid using the Expression function (i.e. I don't want to do it I the SQL script load)?

So my data looks like below.  I don't want products to be included if the Prodtypecode is 200021.  I have tried many ways but cant get it to work?  I have a filter that says IsMember = 'Yes' and that works fine so I don't understand why this wont work.  Any help appreciated.

[tamilarasu]

You can try something like below.

You can also use Aggr function instead of "If" statement in calculated dimension.

=Aggr(only({<ProdTypeCode-={'200021'}>} ProdTypeCode),ProdTypeCode)

[#3]

You can use calculated Dimension or add the filter on the set expression like below ways:

IF( ProdTypeCode <> 20021,ProdTypeCode) and select "Supress Value is Null"

Or

Sum({<ProdTypeCode-={20021}>} Value) --> you can use set expression in your expression to avoid the 20021 ProdTypeCode and relatively its speed when compare to Calculated Dimension.