I appreciate your help, however it might work better if I were able to hide the "#Missing" values somehow.
Another challenge comes from the hierarchy itself: the departments are under the divisions, so if I filter to (e.g.) Div-A, I still get the missing rows.
I will work anyway on your suggestions, hopefully I will come with a solution.
Thanks so much,