How to combine Three dates and three amounts

[Anonymous]

I am trying to calculate Gross Loss.  Gross Loss = Total Chargeoffs - (Total Restitution + Total Payments).  Each of these amounts is located in a different table with different date name, Charge off Month, Recovery Month and Payment Month.  I have loaded all of the appropriate tables into Qlikview and created a pivot for each piece of information.  I tried to create a pivot where my expression is Sum (ChargeOffAmount) - (Sum (RecoveryAmount) + Sum (PaymentAmount)), but because they use different date fields, the totals are incorrect. 

Any suggestions will be greatly appreciated.

[Anonymous]

I will try that as well.  Many thanks for your suggestions.