You are creating a new report in SQL Server Report Builder. You add a SQL Azure data source. Then you add a dataset that has four fields named Year, Country, Category, and Sales. You must design a mat

The Adjacent Below option adds a new row group at the same hierarchical level as the existing Category group but positioned beneath it in the row axis, producing the layout where Category rows appear first followed by Country rows. This creates a side-by-side (non-nested) structure so both groupings independently aggregate their totals without a parent-child relationship. The outer total row then summarizes across both adjacent groups correctly.

Parent Group would promote the new Country group above the existing Category group in the hierarchy, making Category a child of Country, which inverts the intended structure.

Adjacent Above would place the Country group rows above the Category rows, reversing the required display order shown in the diagram.

Child Group would nest Country as a sub-group inside each Category row, creating a drill-down hierarchy rather than the parallel row layout required.