Data Filter on grouped rows

I'm looking for a way to data filter but have multiple rows of data displayed based on one cell of that data.

Each customer record contains 5 rows of data. The Data Filter would be selected based on the final column of Sale, Demo, or N/S.

If i pick Sale, then i need to see all 5 rows of data for that customer along with all other 5-row-data of any other customers with Sale in the last column.

I have attached a small version of my file.

Any suggestions would be much appreciated.

(i've tried to 'group' lines together, representing all lines for each customer, but when "data filter" is used, it only shows the one line for that customer)