[GROUP] Add new columms not grouped after group columms

I have been able to get the result you are looking for by embedding one table in another.

1. Create a table and delete all but one column.


2. Set it to use your data set.


3. Add a parent group to your details group to group on ID. This will add a column for the group.


4. Right-click the group column header and choose Insert Column > Inside Group - Right.


5. Repeat step 4 so you have 3 group columns.


6. Set the right-most group cell to display Name_People.


7. Delete the Details group (Group only, not the associated rows).


8. In the rightmost group column set the right border style to none in both the header and the data rows.


9. In the data column set the left border style to none in both the header and the data rows.


10. Set the width of the data column to minimum possible. (We will not be using it but SSRS requires at least 1 data column).
    
    Steps 8-10 are to hide the fact that there is an empty, skinny column along the right side.


11. Right-click in the middle group column data cell and choose Insert > Table.


12. In the inserted table, delete the header row and 2 of the 3 columns.


13. Set the remaining cell to display Number.

The screenshot below shows the sample I did locally using some TFS data.

---

"You will find a fortune, though it will not be the one you seek." - Blind Seer, O Brother Where Art Thou

Please Mark posts as answers or helpful so that others may find the fortune they seek.