How are subtotals displayed in a multidimensional crosstab worksheet?

• A. As rows only
• B. As columns for the 2nd to last group by dimension
• C. In random order
• D. They cannot be displayed in multidimensional setups

Answer: (B)

Subtotals in a multidimensional crosstab worksheet are displayed as columns for the second to last group by dimension. This method of displaying subtotals helps in summarizing data effectively by providing a clear overview of the aggregated values for each group.

When using multidimensional analysis, each dimension can have multiple levels, and the second to last group represents a logical aggregation point where the subtotal can be calculated. For instance, if you are analyzing sales data by product category and sub-category, the subtotal will appear for the sub-category level before reaching the overall total for the category. This layout allows users to quickly see the breakdown of figures leading up to the final total.

This structured organization of subtotals facilitates better comprehension of the data, as it groups total amounts meaningfully rather than having them scattered or presented in a wholly different context.