Hello all, I am new to the forum but have been reading many of your posts. This problem I’m hitting still has me stumped.
On the data document it lists several items for one person. When I bring the data into my report it creates separate rows for each item on my document, the same person is listed multiple times. I know there has be be a way to bring those rows together so I have the person and then in the column for the items it gives me a list. (I’ve tried to merge them and that did not work.) One line should have the person and all their items. Help, how do I do this???
Try creating a variable for each attribute you need to display. I would make the variables a DETAIL of you main dimension (person’s name?).
Then bring each new variable into the table, after removing all dimensions that are causing multiple rows
