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')
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.