Is there a way to get a report that shows "Last date of Revenue" in Inventory?

Trying to condense our Inventory list to include those items that have been purchased in the last 7 years.

I am trying to find a short cut or report to make "invalid" parts removed from list but not deleted. I don't want to go into each item line by line that is "0" value and parts.

See below as I want to see "Date of Last Revenue" to show date.