8 Replies Latest reply: Sep 6, 2017 7:51 AM by Sunny Talwar RSS

    Find lastvalue in a chart

    Ibrahim Aslan

      Hi Friends,

       

      I need your help.

       

      I make you a example of my question:

       

      Data:

       

      MaterialDocDateTyp
      MAT12300456701.01.2017111
      MAT12300557701.02.2017125
      MAT12300577711.02.2017135
      MAT12300597715.02.2017111

       

      Now I want to see in a table chart for all materials the last date and related Typ, but only if Typ is 125 or 135.

       

      Result:

      Dimension(Material)Expression 1 ( Date )Expression 2 (TYP)
      MAT12311.02.2017135

       

      How can I get this Information. I've tried it with aggr, but it does not work.

       

      Thank you very much

       

      best regards

      Ibrahim