Salesforce Platform Developer Practice Exam

Which report type is used to group both rows and columns of data and show their subtotals?

1. Summary

2. Matrix

3. Tabular

4. Detailed

The correct answer is: Matrix

The Matrix report type is specifically designed to allow users to group data by both rows and columns, making it ideal for analyzing data from multiple perspectives. This feature enables users to create a cross-tabulation of their data, providing a comprehensive view that includes subtotals for each grouping. For example, if you were analyzing sales data, a Matrix report could allow you to group sales by both the sales representative and the product category. This would let you not only see the sales figures for each representative but also how those figures vary across different product categories, all while providing subtotals for each grouping. In contrast: - The Summary report type allows for grouping of rows only, providing subtotals but not the capability to organize data in both rows and columns. - The Tabular report type presents data in a simple list format without any grouping, making it less useful for analysis that requires subtotals. - The Detailed report type provides granular data without summary or grouping features, focusing on the individual records rather than aggregating information. Thus, the Matrix report type stands out for its ability to group and summarize data both horizontally and vertically, making it the correct choice for this scenario.