Which is the report format that allows users to summarize by both rows and columns?

The matrix report format is designed specifically for scenarios where users need to summarize data by both rows and columns, making it ideal for complex data presentations. This functionality allows for the analysis of multiple dimensions of data simultaneously, providing a more comprehensive view compared to other report formats.

In a matrix report, you can categorize data in two different ways: one set of data organizes the rows while another defines the columns. This dual summarization method enables users to quickly identify trends and relationships across various data points, which is particularly useful in large datasets where cross-comparison is essential.

Other report formats serve distinct purposes. Tabular reports provide a straightforward listing of data without the ability to summarize across multiple dimensions. Summary reports allow for grouping and summarizing data, but only in a single dimension—either rows or columns, not both simultaneously. Joined reports can combine multiple report types, but they do not provide the row-and-column summarization feature of matrix reports. Thus, the matrix report format stands out as the appropriate choice for users seeking to summarize data comprehensively across both axes.