Which Row Group option should you select when you add the group?

You are creating a new report in SQL Server Report Builder. You add a Microsoft Azure SQL Database data source. Then you add a dataset that has four fields named Year, Country, Category, and Sales.
You must design a matrix as shown in the following table.

The category rows (the first three rows as shown in the diagram) must present total sales amount by category. The country rows {the next six rows as shown in the diagram) must present total sales amount by country. The total row must present the total sales for each year.
You add a matrix to the report. You add a grouping of the Category field on the rows and a grouping of the Year field on the columns.
You need to add the countries on the rows of the matrix.
Which Row Group option should you select when you add the group?
A. Adjacent Below
B. Child Group
C. Parent Group
D. Adjacent Above

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.