I would like to display 'Departments' when the value is null(Yellow Marked) of SUBGROUP field.
i hope that helps
Use ALT function:
where "0" is the "thing" you want to display instead of null
Retrieving data ...