So I have a page type with a couple of different fields (each is its own field under content):
Department (Field: Department)
Office Affiliation (Content: Office Affiliation)
Center Affiliation (Content: Center Affiliation(s))
I would like to Group the members of each of these in one view, with them being grouped by their specific affiliation (whether it be Department, Office, or Center).
I currently have the view set up in a table and if I only choose one grouping (Grouping field Nr.1) it shows up fine and leaves people without that specific affiliation grouped together without a group title.
For example, by Department:
If I add a second grouping (Grouping field Nr.2) it breaks it entirely to where no names show up and the departments just list without any names in them. Anyone know how to make this work so it's something like this?
Center Affiliation 1:
Center Affiliation 2:
Office Affiliation 1:
Office Affiliation 2: