Custom sorting records in report

[tanyapeila]

So I need help sorting records in a report.


We want them sorted largest to smallest by the total cubic feet, which I can figure out. However sometimes we have multiple records for the same client, we want the records sorted largest to smallet by the total cubic feet by customer code.

For instance:
Customer Codes in this report are: SFWO and SVDH
I want the report to know that when you add all of the cubic feet (last column on right) for the SFWO customers that makes it the majority and put those records before the SVDH customer.

Any help?

[orange]

I think you need to indicate some Grouping on the report as well as Sorting.
Good luck.

[tanyapeila]

Thank you! I sorted by Cube then Grouped by customer Code!

[orange]

Happy to help.

[tanyapeila]

Dang it. I lied. So I want it to group by Customer code, then sum the cubic feet (I'm stuck here) and sort by which Customer has the majority cubic foot.
So it may look like this
SFWO 100
SFWO 300
SFWO 50
SVDH 400