2 Replies Latest reply on Dec 26, 2018 1:13 AM by megha gawali

    Create a new measure from an existed measure

    jiawei yin

      Hi, I have stuck with this problem for a while and cannot find a solution.

      My data set looks like table below

        

      NameidMeasure 1Measure 2
      A10.290.01
      A20.770.86
      A30.730.51
      A40.760.80
      A50.060.36
      A60.030.64
      B10.760.07
      B20.380.49
      B30.620.71
      B40.980.89
      B50.160.71
      B60.390.79
      C10.970.48
      C20.090.55
      C30.310.76
      C40.640.35
      C50.980.65
      C60.520.71

       

      what i want is a table like this. that's to pick the third value from measure 1 and pick the first value from measure 2 and then make them two new measures.

      I knew it can be done by pivot function, but I was wondering if there a way to do the same thing by calculated field or other functions? Thanks in advance.

         

      NameMeasure 1 when id = 3Measure 2 when id = 1
      A0.600.87
      B0.170.36
      C0.790.33