Create Report source sheets? - Merge with same primary?
Update: It works correctly but when I filter it shows the filter on two rows. Can I make it merge all rows with the same primary?
Hi, I created a report and pick both source sheets. The source sheets have the same primary ID however not in the same order. After picking the sources sheets, I pick the columns I want, those columns are created. Why does it only show one source sheet or the other source sheets, but not both source sheets at once? Since the primary ID are the same, should information from both source sheets show up?