3 Replies Latest reply: Feb 1, 2016 6:48 AM by Grace Ho RSS

    Sum value of X Colum based on Text of Y Colum

    Grace Ho

      Hi,

       

      I need a line graph to rep the sum of <2014> for the different <Port>

      result should be as below.

       

      I have tried Sum(2014) but it seems to skip a few rows

         

      Ham= 1287
      LCH = 91

       

         

      Cont_ClassCO_Group_CodeTrade RoutePort2014
      EMPTYNYKEFEHam0
      EMPTYOOCLEFEHam7
      LADENAPLEFEHam243
      LADENHLCEFEHam487
      LADENMOLEFEHam175
      LADENNYKEFEHam278
      LADENOOCLEFEHam8
      EMPTYAPLIALCH9
      EMPTYHLCIALCH0
      EMPTYMOLIALCH0
      EMPTYOOCLIALCH0
      EMPTYAPLEFEHam0
      EMPTYHLCEFEHam24
      EMPTYMOLEFEHam2
      LADENHMMEFEHam63
      LADENAPLIALCH74
      LADENHLCIALCH0
      LADENMOLIALCH2
      LADENOOCLIALCH6