Currently, Analyze only has the ability to report on Department and Parent Department in the same report. I need another level up the hierarchy to include Grand Parent Department as well. We are a large restaurant/retail company with individual locations which are then managed by regional managers then split into larger groups with national managers. I have too many national managers to run individual reports, Department and Sub Departments. I need to run one report that I can then filter and run pivot tables on to report to executive level management.