3 Replies Latest reply: Jan 29, 2013 3:25 AM by torlindstrom RSS

    A rather simple table issue!

      Hi I have data that looks like this:

       

      type

      checkpoint

      year_week

      Actual

      A

      11w47

      Actual

      B

      12w04

      Actual

      C

      12w36

      Actual

      D

      13w04

      Actual

      E

      13w31

      Actual

      FD

      13w10

      Baseline

      A

      11w45

      Baseline

      B

      11w51

      Baseline

      C

      12w26

      Baseline

      D

      13w04

      Baseline

      E

      13w31

      Baseline

      FD

      13w10

      Checkpoint closed

      A

       

      Checkpoint closed

      B

       

      Checkpoint closed

      C

       

      Checkpoint closed

      E

       

      Checkpoint closed

      FD

       

       

      I would like to present it like this:


      A

      B

      C

      D

      E

      FD

      Actual

      11w47

      12w04

      12w36

      13w04

      13w31

      13w10

      Baseline

      11w45

      11w51

      12w26

      13w04

      13w31

      13w10

      Checkpoint closed


       

       

      I have tried to set it up as a table with “type” as dimension and with the expression :

      if(Sum(checkpoint='A'),year_week)

       

      But it doesn’t work, please help me out! Please see attachment!

       

      Thanks for the help!

       

      Tor Lidnström