Crosstabs

Use crosstab reports, also known as matrix reports, to show the relationships between three or more query items. Crosstab reports show data in rows and columns with information summarized at the intersection points.

For example, the following crosstab shows the gross profit and revenue by product line for each year.

a crosstab showing gross profit, revenue, and cost of goods sold by year by product line
Tip: The Same Month Prior Year sample report in the Sales and Marketing (cube) package includes a crosstab.