4 Replies Latest reply on Aug 15, 2018 9:40 AM by Gurpreet Singh Goraya

    Aggregated values based on first three numbers

    Gurpreet Singh Goraya

      Hello All,

       

      I am seeking help to aggregate values based dimension. If dimension first three values are same, I need to aggregate them. In the provided example I want an aggregated value of  Fruitid  like 102 &102BD, 104 & 104BD. Please advise. I would appreciate the help. Thanks

       

       

      FruitidQuantity
      1012
      1025
      102BD6
      1036
      1047
      104BD8
      Expected Result
      FruitidQuantity
      1012
      10211
      1036
      10415