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