Merged Dimension - #Multivalue

[former_member277624]

Hi

I have 2 queries.

Query 1 - Personal Reference:People and Name:Next of Kin

Query 2 - Personal Reference:People and Pension Scheme

I have created a merged dimension on Personal Reference:People

I have created a detailed variable called Pen and associated it with the merged dimension Personal Reference:People

As you can see from the screenshot. When I display the Next of Kin just with the Personal Ref No I get the correct results (1st table on the screenshot), likewise, when I display the Pension scheme with the Personal Ref No I get the correct results (2nd table on the screenshot)My problem comes when I bring in the merged dimension called Pen. As you can see in the 3rd table of the screenshot I just get the #Multivalue message instead of the data results.How can I resolve this problem.

[former_member198519 · Accepted solution]

Select the last table and go to format table and select the option as "avoid duplicate row aggregation". I just created a sample report. Below is the screenshot for the same.