My data is such that I get duplicates of some information, so I use a formula to calculate a distinct sum in the footer of each group, and I suppress the details portion. I also calculate the percentage based on the total distinct sum. Now I need to sort all of these records so I get the greatest percentage first, then descend from there.

Choosing distinct records still gives me duplicates because of how the data is setup. Say an order can have multiple companies associated with it. I would only want the order counted once for the overall order total and I would still want to group each company together to show its individual sales, even though those order numbers might appear with another company as well. Does that make sense?

Thanks for the suggestion about the distinct records. I eliminated a couple fields that I was showing, which made the records distinct, so I am getting the correct results now. Thank you!!