4 Replies Latest reply on Sep 5, 2018 9:08 PM by Josimar Mireles

    "WHERE" Clause for a TOP in filters

    Josimar Mireles

      Hi everyone!

       

      I have the next situation:

       

      I need to show the top IDs that has the high percentage of misreport in the last date

       

      So  in the filter section I need to create a calculated field similar to this SQL statement:

       

      Select TOP 10 avg(Misreport)

      where max(month(DATE)) }

       

       

      Porcentaje Misreport = Percentage

      Fecha Cierre = Date

       

       

       

      Any ideas?

       

      Thank you in advance