Group records with unique sequence

[bharlow]

It's been a while since I been out to AWF and I hope everyone is doing well!

I am trying to write a query that will group sales records by sale number and set type, but when the sets are the same the query groups incorrectly. I do not know how to create unique group points.

Here is an example data set:
SALE#PRICETYPESIZESEQGROUP64906000 $ 782.09 MATTRESS3010MB3064906000 $ 782.09 MATTRESS3011MB3064906000 $ 258.00 BOX3020MB3064906000 $ 258.00 BOX3021MB30

Here is the result of the current grouping:
SALE#GROUPSUMOFPRICESEQ64906000MB30 $ 782.09 1064906000MB30 $ 1,298.09 11

Here is what the result should be:
SALE#GROUPSUMOFPRICESEQ64906000MB30 $ 1,040.09 1064906000MB30 $ 1,040.09 11

Thank you in advance for your time!