4 Replies Latest reply on Nov 21, 2016 5:19 AM by Chris Beck

    Filtering to get individual averages

    shahana.syed.0

        Hello Everyone,

                This is a sample of the dataset I am working on and some LOD calculaitons have been used to get the values in columns already. The last row gets the average of all the columns, I am trying to achieve individual average values for A, BC,D and E when I apply the ID filter.

      Appreciate all the help!

       

                  ID          A           B         C            D         E
      10.340.5770.7580.240.082
      20.450.5460.7210.170.230
      30.560.1890.7540.1640.462
      40.560.8550.8870.740.016
      50.330.2230.9790.3010.210
      60.220.2220.8460.0090.986
      70.10.3810.2310.2100.730
      80.70.0590.2570.9280.170
      90.80.4160.4030.9180.216
      100.60.4630.3550.9250.243
      Average0.4660.39350.62020.4623590.334966