2 Replies Latest reply: Jun 18, 2012 11:12 AM by Asier Barredo Barbero RSS

    If row value changes

      Hello everybody,

      I'm new here and this is my first question.

      Im trying to get a moving MAX value for the colummn MENGE which should change, when the text value on the colummn ARTNR also changes. I'm looking for the MAX MENGE value for each article and this value should be displayed and repeated for all the rows with the same ARTNR.

       

      Here you have the structure of my data. It ´d be very glad if you could help me.

       

      Thank you very much

       

      Urdru.

       

       

      ARTNRLHMNRSEKTORNRMENGE
      -
      000.3-60-0000.5-L4301723
      000.3-60-0000.5-L4303029
      000.3-60-0002.0-L4169913
      000.3-60-0003.0-L4209221
      000.8-42-2-R4264626
      000.8-42-8-L4272413
      000.8-42-10-L43016215
      000.8-42-10-R4259117
      000.8-42-16-R4232515
      000.8-42-24-R4306425
      000.8-42-40-L42634216
      000.8-42-40-R4260821
      000.8-42-50-R4283912
      000.8-42-72-R4296523
      000.8-42-100-L42605216
      000.8-60-4-L4183518
      000.8-60-6-L4210723
      000.8-60-8-R42280210
      000.8-60-10-L42782211
      000.8-60-16-R4199733
      000.8-60-24-L4181341