Hierarchy Slicer - Unexpected Error

Hi Jan. Works perfectly here :smileyhappy:

I just played around with the possibilities and have a bit of feedback. I often work with an organizational hierarchy where ragged hierarchies are very nice to have, but I have the employees in each department in another table and would really like to be able add them to the hierarchy – I am able to do this, but when turning “Empty Leafs” off all employees belonging to an empty leaf are not shown. What I am doing are the following:

Table “Employees”:

Dep num:        Name:

1                       Jan

2                       Martin

2                       Anders

Table “Organization”:

Dep num:         Org Level 1       Org Level 2

1                       Sales

2                       Sales                 EU

Where Dep num is used to link the two.

With “Empty Leafs” turn on this shows as:

Sales – (Blank) – Jan

Sales – EU – Martin

Sales – EU – Andres

With “Empty Leafs” turn off it becomes:

Sales

Sales – EU – Martin

Sales – EU – Andres

It would be really nice if it could remove the blanks but show “Jan”, at the level where he belongs:

Sales – Jan

Sales – EU – Martin

Sales – EU – Andres

Not a deal breaker as I can probably merge the two tables to get a similar behavior, but if it was part of the visual it would be really nice J