View to Only Show Unique Values of a Column


#1

My records are identified by a 9 digit number. The first 6 digits of these numbers are parent groupings of the values.
12356789
123456555
123456111
654321999

I’d like to create a view that only shows 1 of each 6 digit option. Filters 1 of each unique 6 digit. While also having the other columns that are associated with each record.

I have a page designer export set up for this view and instead of exporting an export record for each 9 digit record. I’d like to be creating an export record for each 6 digit.

Please Assist