10 Replies Latest reply on Oct 2, 2018 8:12 AM by Sai Sri B

    Any top 10 records without Index

    Sai Sri B

      Hi Team,

       

      I have a report where I do not have measure in it.

      Requirement: I want to show any top 10 records from the view.

      Please note that I do not want to use Index() as it will assign the number for each record and then apply the filter on that like index()<=10, because I've 1M records in my view out which users wanted to see just ANY 10 records. If  I use Index() then it is taking long time to get just 10 records.Thus, I do not want to use Index() function

      It is something like in SQL

      SELECT TOP 10 from table

      Attached the .twbx file