Pivot Table expression

[#1]

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

[#2]

Hi,
try expression

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

Alex