Removing duplicates when "Serial Number" is the same
We have an internal table that holds an inventory of currently available items and we want to only display the unique values(e.g. each different make/model). The problem is that each item has a unique serial number which is preventing the report's "remove duplicate rows" functionality from just removing the duplicates. Is there a way to disregard the serial number column?