Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to show only rows 'NameProduct' (column 1) with condition negative difference between columns 2 and 3 :
Column 1 = Dimension = NameProduct
Column 2 = Expression = Sum(QuantityProductInventory)
Column 3 = Expression = Min(SafetyStockLevel)
Column 4 = Expression = Sum(QuantityProductInventory) - Min(SafetyStockLevel)
you can try with a calculated dimension
if(aggr(Sum(QuantityProductInventory) - Min(SafetyStockLevel), NameProduct)<0, NameProduct)
and check the "Suppress When Value is Null" flag in Dimension tab
you can try with a calculated dimension
if(aggr(Sum(QuantityProductInventory) - Min(SafetyStockLevel), NameProduct)<0, NameProduct)
and check the "Suppress When Value is Null" flag in Dimension tab
Perfect !!! Thx a lot...
Stanley