How to have a distinct value of containers in slicer

[NoorHakim21]

Hi Guys, 

This app is for Seal and Container Verification. Not sure how to proceed.

My Job ID is the unique ID which is the key.

I have a few lines that have the same container and seal no. I want to group them together where there are no repeated value. 

How do i do this. Thank you

[AleksiAlkio]

One way is to create a slice that hides all other rows away except the latest. It would be something like..
[Job ID]=
MAXROW("TableName","_rownumber",
AND([Container No]=[_THISROW].[Container No],[Seal No]=[_THISROW].[Seal No])
)

More details from here https://support.google.com/appsheet/answer/10107920?hl=en&sjid=15511545753398762630-EU