You could make a summary field for the SKU, which the summary field will only work if made into a sorted report that has subsummary parts. You first sort by SKU (which the subsummary would depend on), then by the summary field.
Thanks for the help,
Not sure if that will work.
I just tried it..
I need it to be a Filter, not a sort.
I still need to be able to sort my records different ways. (SKU, Description, Date, Etc..) and have it "hold" the filter.
Thanks for the help
The total sales that you describe would most easily be produced from a related table where you have one record for each SKU. Using a relationship and aggregate functions, you can get total sales for each SKU--either over all the records in your original table or all those for a given time period.
Thank you Phil!!!!