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?
Gelöst! Gehe zur Lösung
Gelöst von Alfredo_Medina. Gehe zur Lösung
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.
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.
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.