Organising a panel schedule by quantity

[KentBurns]

I may be missing something simple but:

I have a panel schedule, and I want to sort it so that the Most Used panel type is at the top, and the unique panels are listed at the bottom. - I would have thought I would sort by Count but [Insert argument about how count isn't a thing and why would you want it to be a thing], and it's unavailable as an option -

i.e.

Panel Type 01 - 500

Panel Type 04 - 375

Panel Type 03 - 175

Is there a way to achieve that that I'm missing??

Obviously one could rename the panel types so that alphabetical = numerical, but that seems like a ludicrous backwards step. 

Thoughts anyone?

[Alfredo_Medina · Accepted solution]

I don't think that it is possible to use a subtotal value as a criteria for sorting the data. You might need to use something else, like entering a value in the Type Comments parameter after knowing the results.

[KentBurns]

Thanks for your reply - I thought that might be the case, which makes me tremendously sad inside. Seems like a strange function to omit right? Just let us sort by count.

I'd put the type comment in the same category as renaming the types themselves so will just deal with it in excel.