<p>Hello All,</p>
<p>
I am attempting to concatenate or show multiple values of an intersection between a row and column. Since the data will be dynamic, it sounds like using a Cross Tab and data cube would be best in achieving this.</p>
<p> </p>
<p>In the attached screenshot below, I'm using State and Size as a grouping in associated rows and columns, with Person as the Summary (intersection between the two).</p>
<p> </p>
<p>I'm able to pull in a String value using the FIRST function, however I'm trying to show multiple values in that Summary Section and it will not show all of them. It's as if I want to CONCATENATE or aggregate those 3 person names, but there is no such function to use....</p>
<p>
In the attached screenshot, I have my data set as such w/ the intended output below.</p>
<p> </p>
<p>However, in attempting this. For that first cell (Between State A and Small) it will only show <strong>John</strong>.</p>
<p>How can one create a table or show all the information as such? Is there another way to display the information as intended?</p>
<p> </p>
<p>
