I am trying to sort a sum in descending order among multiple families. Each family has a series of groups. What is happening is that the "overall" highest is being sorted first, regardless of if it is first in that family (see attachment). I want it to have a separate sort for each family. Is that possible without manually sorting?
Thanks for the help!
It sounds like you want to do a nested sort. The following link provides further information on how this can be done:
Hope this helps!