3 Replies Latest reply on Nov 1, 2016 5:22 AM by Mahfooj Khan

    mix aggregate and non-aggregate arguments

    Y Lu

      at my working place,  SQL query needed to be avoided as possible.

      how can I convert this logic into tableau without SQL:



      select * from

      tableA where planNumber < Max(planNumber)


      be aware, the value

      Max(planNumber) is having a filter such as where Zone between 6 and 12.


      does anyone have any idea?