Merged Dimension in Web I and display multiple values

[former_member1202267]

I have 2 Queries - one from Database and other from excel in Web I. I merged the common dimensions between them .However, other objects in query 2 when set as Detail object and dragged results in multi-value error. I do not want try max or sum function to display only single value. Is there a way to display all the values in the report.

Query 1 :

Col1 Col2

P1 IL

P2 KY

P3 FL

Query 2:

Col A ColB

IL Chicago

IL Springfield

KY Lexington

KY Louisville

FL Miami

Merged Col 2 and ColA. Col1 is Detail object of Col 2 and Col B is detail object of Col A.

I tried checking " Extended merge Dimension values"

Result obtained :

Col1 ColA Col B

P1 IL # multivalue

P2 KY # multivalue

P3 FL Miami

Expected Result :

Col1 ColA Col B

P1 IL Chicago

P1 IL Springfield

P2 KY Lexington

P2 KY Louisville

P3 FL Miami

[amitrathi239]

format table-checked the check box "avoid duplicate row aggregation " and try