Hi, Do you require the rows in the same order as your result for sample data, or it is just the hierarchical relationship between employees that counts? For example, is the following acceptable? Name Level by_self by_sub total ---