Using Date within a Pivot Table Calculated Field ?

[klong]

Hi,

I'm struggling to get a Calculated Field in a Pivot Table to do what I expect.

I wanted the Raw Data below in a pivot table where I would show OPEN and RECEIVED Qty columns. The blank Receipt Date puts 500 in the OPEN Qty column. Note data row 4 and 5 are the same item therefore pivot should have 100 in RECEIVED and 500 in OPEN column

MPN ---- Qty ---- Due Date ---- Receipt Date

GJM1555C1H5R0CB01D ---- 100 ---- 07/06/2019 ---- 06/06/2019
GRM155R70J105KA12J ---- 500 ---- 04/06/2019 ---- 04/06/2019
GRM219R60J476ME44D ---- 160 ---- 07/06/2019 ---- 06/06/2019
GRT31CR61H106ME01L ---- 100 ---- 04/06/2019 ---- 04/06/2019
GRT31CR61H106ME01L ---- 500 ---- 12/06/2019
ILA.02 ---- 30 ---- 31/05/2019 ---- 31/05/2019
IRF9328TRPBF ---- 30 ---- 31/05/2019 ---- 31/05/2019

In the Calculated Fields in the Pivot Table I used "=IF(ISBLANK('Receipt Date' ),0,Qty )" for RECEIVED and =IF(ISBLANK('Receipt Date' ),Qty,0) in OPEN. The result just gives all 600 in RECEIVED and 0 in OPEN.

Am I doing something silly that I can't spot ?

Regards,
Ken