Need help in grouping sorted fields? Not even sure this is possible.
"SS" is the brand and the floor plan is "2300"
"FR" is the brand and the floor plan is "2301"
So (2) different brands, but on paper the floor plans are identical. We use the #1 to designate which floor plan is which.
So in "SS" you have 2300, 3100, 3120. In "FR" the same exact floor plan is called 2301, 3101, 3121.
My problem is...when I want to see what is the top selling floor plan I would like to group these together (2300 & 2301) since they are the same layout. Right now I have a script that will pull the best selling floor plan for "XX" model year. It is sorted by model and it splits those up. So it counts the number of 2300's and separately it counts how many 2301's. Is there a way to use some sort of wild card to group those together, or would I need to change all the floor plans to a single number like 2300/01?