Tableau Crosstab Report

Table Crosstab in Tableau is the best way to display data in multi-level. In this article we will show you, How to Create a Tableau Crosstab Report with example.

Create a Tableau Crosstab Report

For the Tableau Crosstab demonstration, we are going to use the data present in Global Super Store Excel Work sheet. So, Please refer Connecting to Excel Files in Tableau article to understand the connection settings.

Dragging any Dimension field to the Rows section will automatically create a table for you otherwise, select Text label will do the trick. Let me drag Country from Dimensions Region to Rows shelf.

Next, drag and drop the Quantity from Measures Region to Text field present in Marks Shelf. Now you can see the table report

Let me add Sales field to Measures shelf

Let me one more Measures called Profit.

To convert this Table to Matrix. Drag and drop category field to the Columns Shelf

Now you can see the Matrix

Let me add one more dimension (Market) on Columns shelf

You can also add fields on Rows shelf to group row fields