1 Reply Latest reply on Feb 15, 2013 4:22 PM by Tracy Rodgers

    I want to display the oldest 5 records in my data source on a dashboard.  How can I do this?

    mark bologna

      I have a datasource containing all my open claims (approx. 15,000).  One characteristic of these records is date of claim.  Other fields include file #, agent assigned to the work, days pending in each stage of the process.  The datasource is not sorted by date of claim.  I cannot figure out how to create a worksheet that will filter down to only the 5 oldest claims by date, and then the 5 oldest within each stage of the process.

       

      A sample workbook is attached.

       

      Thanks,

      Mark