If condition in calculated field

Hi,
I have a table which I cannot modify, so I have to try and get this data through pivot table.

Here is the sample data -

order id, orders
fndsfs, 9
nskfs , 8
, 5
, 4

I want a pivot table that will show me below type of pivot =

"Blank Order Id" | "Non Blank Order Id"
9 | 17

I believe I can do this if I use "if" condition in the calculated item. Please help.