I want see in table only line with ItemId have not null value SalesQty or InventQty, but may be this ItemId have LastPricePurch and LastPriceSales and option on Dimension "Supress when value is null" - not working.
Now I write expression in Dimension: =aggr(If(Alt($(SalesQty),0)<>0 OR Alt($(InventQty),0)<> 0,ItemId ),ItemId )
It's work, but slowly - how I can optimaze this situation?