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?

      thanks