5 Replies Latest reply: Dec 9, 2015 1:25 PM by Sunny Talwar RSS

    Aggr and only?

      I started with a table like this.

          

      Dim 1Dim 2Dim 5Dim 6Expression
      AC2015-01-12SSUM(something)
      AC2015-02-13T..
      AD2015-04-19U
      BE2015-01-03V
      BE2015-02-12X

       

      The result I wanted was to get the highest date (Dim 5) over Dim 1 and 2.

      With an aggregation like this:

       

      =Date(Aggr(DISTINCT max(Dim 5),Dim 1, Dim 2),'YYYY-MM-DD')

       

      ..I got something good to start with:

          

      Dim 1Dim 2Dim 5Dim 6Expression
      AC2015-02-13SSUM(something)
      AC2015-02-13T..
      AD2015-04-19U
      BE2015-02-12V
      BE2015-02-12X

       

      Now to my question - how do I filter Dim 6 so I only get the one that 'connects' to the highest date?

      As a result as below?

          

      Dim 1Dim 2Dim 5Dim 6Expression
      AC2015-02-13TSUM(something)
      AD2015-04-19U..
      BE2015-02-12X