Demension Creation Query

[#1]

Quetsion1:

There's no indicatior with "Repl. Type"in raw data, so i want to add a filter pane in the page as below:

The logic is: if column" A" contains 'WEB', shows “WEB”, If not(Others), shows " Non-Web“. I tried to input the fx as below, which truned out to be wrong. 

=IF([Customer purchase order number]='*WEB*','WEB','Non-WEB')

Question 2:

I want to add a filter pane which could be drilled down to: 1st) Data Type( "Backlog",'Shipment", "Delivered", "Partial Shipment"; 2nd OTS (days)

The logic is:

If Column C /= 0, Column D=0, Daty type shows 'backlog', if we drill down, OTS shows days, The days = PSD( Column E) –SO Create Date( Column F)

If Column C  =0, Column D /=0, Daty type shows "shipment" => drill down: OTS = GI Date(Column G)– SO Create Date(Column E)

If Column C =0, Column D =0, Daty type shows "delivered" => drill down: OTS = GI Date(Column G) –SO Create Date(Column E)

If Column C /=0, Column D/=0, Daty type shows 'shipment' => drill down: OTS =PSD( Column E) –SO Create Date(Column E)

Attached with tested Raw data, appreicate your kindly help on it. Thanks a lot.