<p>I have the following report</p>
<p> </p>
<p>Plan Strategy Project</p>
<p>
</p>
<p>Plan 1 Strategy 1 Project 1</p>
<p>Plan 1 Strategy 2 Project 1</p>
<p>Plan 1 Strategy 3 Project 1</p>
<p>Plan 2 Strategy 4 Project 2</p>
<p>Plan 3 Strategy 5 Project 3</p>
<p>Plan 4 Strategy 6 Project 4</p>
<p>Plan 4 Strategy 6 Project 5</p>
<p> </p>
<p>where I want to group each column to display one instance of each (Plan, Strategy and Project) as follows:</p>
<p> </p>
<p>Plan Strategy Project</p>
<p>
</p>
<p>Plan 1 Strategy 1 Project 1</p>
<p> Strategy 2 </p>
<p> Strategy 3 </p>
<p> </p>
<p>Plan 2 Strategy 4 Project 2</p>
<p> </p>
<p>Plan 3 Strategy 5 Project 3</p>
<p> </p>
<p>Plan 4 Strategy 6 Project 4</p>
<p> Project 5</p>
<p> </p>
<p>I was able to group them but I had to create 3 different group instances and the columns where skewed, one under another and it is difficult to follow where the info belongs.</p>
<p> </p>
<p>Plan</p>
<p> Strategy</p>
<p> Project</p>
<p> </p>
<p>Also, I have a prompt window with an "All" function. I tried creating 3 different tables for each columns, which it worked when I select one instance at a time but when I select "All" the tables are off. </p>
<p>I've struggled for quite a while only being able to group one column, hopefully someone can give some pointers as how to tackle this problem.</p>
<p> </p>
<p>Thanks,</p>
<p> </p>
<p>Jorge</p>
