Creating report to show Parent Row based off Child Row
I am trying to design a report to list to our outside salesman. I need to filter it based on contractor names, but those are child rows to the parent row which is the job name.
So in the picture, I would want the criteria to be "ROMANOFF", so I could pull all jobs they are on, which in this case, would be 12th Avenue South.
Is this possible? I do currently have a helper column that allows me to identify parent/child rows by numbering them. Parents are 1 then children are nothing, but don't know if that is enough to achieve this.