Hi, I have two sheets I'm putting into a report. They have different primary columns. I wanted to group by the first sheet's primary column and pull in additional information for the second sheet that has been matching and no matching column headers. But when I pick primary in group, it will only use the second sheets' primary information, which I don't want. I decided, instead, to group by company name, which is not a primary column but both sheet share. Which will work, however, all the columns from sheet one are blank. Why will it not show the information from sheet one? Do the primary columns in both sheets in the report have to match?
Thank you
