Organization Chart

[EGilbert]

I am working on an org chart and I have a number positions that are not currently filled.  They have position IDs but the names are showing as vacant.  I would like to exclude these when building the structure.  Is it possible to use set analysis focusing on employee name including 'vacant' or another field like employee id which would be blank? 

[KGalloway · Accepted solution]

You could use an if statement in the primary dimension of your org chart. Here is an example:

The if statement in the dimension: if(label <> 'vacant', id) only allows ids with a non-vacant label to show. Everything else is set to null and the we uncheck the include null values box.

Let me know if I can clarify anything.