A two-dimensional table that displays the joint frequency distribution of two categorical variables.
Provalo con l'IACross tabulation, often referred to as a contingency table or crosstab, summarizes the relationship between two variables by showing counts or values at the intersection of rows and columns. In Excel, this is most efficiently created using a PivotTable to aggregate data across categories.
A table showing 'Product Category' as rows and 'Region' as columns, with the cell values representing the total units sold for each specific combination.
Select your data range, go to the Insert tab, click PivotTable, and drag one category to the Rows area and another to the Columns area.