Hello,
I have many child departments and reporting on all these departments will make the search too big so would like to report on only the parent department and consolidate all the amounts from the child departments. I haven't found any "parent of" or "sub of" fields in the search. Any suggestions? Thanks.