My records are identified by a 9 digit number. The first 6 digits of these numbers are parent groupings of the values.
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.