Only show last 10 values

I have 5 unique items that I perform inspections on. I need to find the results for only the last 10 inspections, regardless of the date range.  Is this a formula or some sort of filtering tool?

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • melissa hodges - You can assign a unique no to each row based on your criteria using a cumulative_sum function as below

    for example: Rank = cumulative_sum (1, product no , inspection id, inspection type ) 

    this will create unique numbers for each of the row by product no , inspection id, inspection type. You can use the filter Rank < 10, this will restrict the records.

    Hope this helps.

    Like 1
Like Follow
  • Status Answered
  • 2 mths agoLast active
  • 1Replies
  • 30Views
  • 2 Following