14 Replies Latest reply on Feb 11, 2016 8:17 AM by Alexander Mou

    Calculated Field to capture another row's value

    Cynthia Wang

      Hi I'm wondering whether this is doable in Tableau:

       

      Let's say my data looks like the first three columns shown below. Then how can I add a calculated field that captures the first non-null Code from the third column for the same ID across  the months?

       

      ID_noMonthCodeResults Wanted
      a0NullEX
      a1NullEX
      a2EXEX
      a3NullEX
      a4NullEX
      b0NullLS
      b1LSLS
      b2NullLS
      b3NullLS
      b4OPLS

       

      Thanks in advance!

       

      Cynthia