Is it possible to Alpha Order a Named Set?
I have a named set with specific client names. Sales reps earn a special commission on sales to these clients. If the Client was added in Month 1, any revenue in Month 2 or 3, etc is also eligible for the special commission so the named set list continues to grow.
I have been manually alphabeting the client names as they are added. The named set now has over 600 members and that has become quite cumbersome.
I’ve used the MDX Order function previously but never with a Named Set.
Thank you.