0 Replies Latest reply: Sep 21, 2017 7:11 AM by Amber Yang RSS

    Demension Creation Query

    Amber Yang

      Quetsion1:

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

       

      鎹曡幏.JPG

       

      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.