2 Replies Latest reply on Dec 8, 2016 10:13 AM by Dawit Gelan

    Calculated Field Based On Specified Dimention

    Dawit Gelan

      Hello,

       

      I am trying to create a calculated field (not a table calculation) that has the amount each person had at Time 1. Here is the intended output below.

       

        

      PersonTimeAmountTime 1 Amount
      p1188
      p1268
      p1378
      p1428
      p2199
      p2259
      p2389
      p24109
      p3177
      p3267
      p3397
      p3487

       

       

       

      Does anyone have an idea of how to create a calculated field that computes 'Time 1 Amount' column above ?

       

      Thank you!

      Dawit