1 Reply Latest reply: Aug 27, 2010 4:32 AM by Alessandro Neri RSS

    Pivot Table expression

      What I am looking for is an expression which calculates the SUM COST only for a field where the TRANSACTION_CODE = 'SCP'

       

      Here is what I have so far but it is not displaying what I am looking for

       

      Sum ({$<COST = [$(OverviewInventoryTransHistory.TRANSACTION_CODE = 'SCP'))}>}

       

      I am new to Qlikview and any help would be much appreciated