Consolidating lines in a union report table
I have a union report below, in one of the unions I have req data and the last column is SUM(0)
In the other union I have all columns with the statement of '' except for the ID column, which reports the same value that I have in the first union, the last column reports prospects, which works good.
If I only show the number of prospects the ID will consolidate and sum to 2 - works good.
I need to be able to add in the other variables so the lines will collapse and show me the correct count of prospects for each ID. I know the '' is throwing off the line but I don't know what to do to get it to consolidate with the first union. Thoughts?