Attached picture is my scenario, this is PIVOT Table 1. ITC_Code is 'itemcode' 2. inv_shop_id_f is my 'shopid' 3. 'PC' in expression is the 'Status' showing that the these item codes are 'closed' at this shop Question is: I want to show the Balance in the box where Status is not 'PC', my expression for the balance calculation is 'sum(inv_qtyin)-Sum(inv_qtyout)'
