BI #MULTIVALUE error when grouping

[denis_konovalov]

Hi, I am using 3 linked queries to build a hierarchical report of committees and subcommittees from a flat table of parent-child references. I've been able to get the results I want from my queries as below (1.), but when I set the first two columns as Sections I get the #MULTIVALUE error shown below (2.). If I undo the the inner Section, then it works fine (3). Any suggestions for fixing this problem with the inner section? I would like to be able to nest the Sections no matter how many levels of parent-child relationships. I only have permissions to use the BI platform and do not have access to the universes Thank you.

Figure 1.

Figure 2.

Figure 3.

[denis_konovalov]

I have fixed your tags, please do select more careful next time.

[Former Member]

Mahboob, If I change from detail to dimension then I get a #DATASYNC error. Below are screen shots of the query results and the individual query setups. Thanks!