Sorting by Usage then Item ID Based on Location

[jalouw]

I have a spread sheet that has usage numbers for items based on location of the item being used. I have to sort the spreadsheet to give me the item that has the highest usage for the past 90 days, but then gives me the item ID information for the other branches associated with it. Currently when I sort, it gives me 90 day usage ranked largest to smallest. I want This ranked by usage, then by location. I have given a sample of what I'm getting when I sort. The H2C has usage associated with it at other locations. I want all the 10009513-C and all the usage associated with it at other branches at the top, and so on and so forth going on down.

Item ID

Item Desc

Location ID

Qty On Hand

Minimum

Maximum

Last 90 Day Usage

<tbody>
</tbody>

10009513 -C	RGX-N-05-986 MALE NIPPLE	580	112.00	1,120.00	2,240.00	11,191.00
B20-5B-BULK	COUPLER (BP) |P100N	580	1,200.00	0.00	0.00	2,300.00
PS6905JM-6-6	SWIVEL ASSY |P5YB1	545	514.00	625.00	750.00	1,100.00
PC306-BP	NON-VALVED COUPLER |P5NB100	585	99.00	10.00	20.00	690.00
PN353	NON-VALVED NIPPLE |P20NB250	585	180.00	10.00	30.00	654.00
EZ-251-6MP	COUPLER (OLD # EZ304M-6T) (IL) |P10YB1	545	0.00	0.00	0.00	550.00
SST-N3M	NON-VALVED NIPPLE |P5YB1	583	103.00	20.00	100.00	500.00
H2C	NON-VALVED NIPPLE |P20NB200	585	293.00	200.00	300.00	453.00

<colgroup><col><col><col><col><col span="2"><col></colgroup><tbody>
</tbody>

 

[SpillerBD]

Use the multi-sort feature.
https://support.office.com/en-us/ar...or-table-62d0b95d-2a90-4610-a6ae-2e545c4a4654

 

[jalouw]

I've tried that and it didn't work. It will group the highest usage items together. I need to group by usage then item ID.