What is the difference between a row-level focus and a column-level focus in a report?

• A. Row-level focuses on measures, column-level on row grouping.
• B. Row-level emphasizes measures displayed by rows; column-level groups by columns.
• C. Row-level emphasizes grouping of rows; column-level emphasizes measures and values displayed along columns (as in a matrix).
• D. Both are identical in a typical cross-tab.

Answer: (C)

Row-level focus means the report’s structure is driven by grouping data along the rows. You define row groups (like region, product category) and the data is organized and summarized within each row. Column-level focus shifts the emphasis to the column axis, organizing data across columns and typically presenting the measures in the intersecting cells of a matrix or cross-tab. In that setup, the columns define the layout (for example, time periods or categories), and the values live in the cells under those columns. So, row-level is about how rows are grouped; column-level is about how data is laid out across columns with the measures shown in those columns. For instance, a cross-tab with regions as rows and quarters as columns demonstrates row-focused grouping by region, with the quarterly measures displayed across columns.