Creating Text Tables and Crosstabs in Tableau

Course Topic: Tableau Data Visualization and Reporting

Learning Objective: Understand text tables and crosstabs, create tables using dimensions and measures, display multiple measures, calculate percentages, add totals, format values, apply filters, and build interactive reporting dashboards in Tableau.

Course Link: JustAcademy Tableau Training

Demo Link: Register for a Tableau Course Demo

1. Introduction to Text Tables and Crosstabs

A text table is a data visualization that displays information in rows and columns using text and numerical values. It is useful when users need to examine exact values, compare records, review summaries, and find specific information within a dataset.

In Tableau, text tables are also called crosstabs or cross-tabulations. They organize data using dimensions as row and column headers and measures as values within the cells.

Text tables are similar to spreadsheets and pivot tables in Microsoft Excel. They are commonly used in business reports, financial summaries, sales analysis, inventory reports, performance monitoring, and operational dashboards.

Example

Suppose a company wants to compare sales across product categories and regions.

This table allows users to identify sales values for specific category-region combinations and compare the totals across regions and categories.

Why Are Text Tables Important?

• They display exact numerical values clearly.
• They organize large amounts of structured information into rows and columns.
• They help users compare values across dimensions.
• They support detailed business reporting.
• They can show percentages, subtotals, and grand totals.
• They can complement charts by providing precise values behind visual trends.
• They can be formatted with colors, labels, and number formats to improve readability.

2. What Is a Crosstab in Tableau?

A crosstab is a table that summarizes data by arranging categories across rows and columns. The intersection of a row and a column displays a value for the corresponding combination of dimensions.

For example, if Region is placed on Rows and Category is placed on Columns, each cell can show the sales value for a particular region-category combination.

Example of a Crosstab

Each row represents a region, each column represents a product category, and each cell displays the sales value for that combination.

Common Uses of Crosstabs

• Sales by region and category.
• Profit by year and product sub-category.
• Employee performance by department and quarter.
• Student marks by subject and class.
• Expenses by department and month.
• Customer counts by segment and region.

3. Difference Between Text Tables and Crosstabs

The terms are often used interchangeably in Tableau. A text table is the general presentation of values in a table, while a crosstab commonly emphasizes cross-classifying data by two or more dimensions.

4. Understanding Dimensions and Measures

Dimensions and measures are fundamental to creating text tables in Tableau.

4.1 Dimensions

Dimensions are fields that categorize or describe data. They commonly create the row and column headers of a text table.

Examples include Region, Category, Sub-Category, Customer Name, Product Name, Order Date, and Segment.

4.2 Measures

Measures are numerical fields that can be aggregated and analyzed. They commonly appear as values within the table cells.

Examples include Sales, Profit, Quantity, Revenue, Discount, and Number of Orders.

4.3 Example Field Arrangement

Important: Tableau may automatically aggregate measures. Always check whether the table should display SUM, AVG, COUNT, COUNTD, MIN, MAX, or another appropriate calculation.

5. Understanding the Tableau Workspace

Before creating a text table, understand the main areas of the Tableau worksheet.

Data Pane

The Data pane displays the dimensions and measures available in the connected data source. You can drag fields from this pane to the Rows shelf, Columns shelf, Marks card, and other worksheet areas.

Rows Shelf

The Rows shelf defines the row structure of the table. Placing Region on Rows, for example, creates row headers for the regions.

Columns Shelf

The Columns shelf defines the column structure. Placing Category on Columns creates a separate column for each category member.

Marks Card

The Marks card controls how data appears in the view. For a text table, the mark type is typically Text, and measures are placed on Text to display values inside the cells.

Text Property

The Text property determines the text displayed within each mark. A measure placed on Text can show values such as sales totals or average profit.

Filters Shelf

The Filters shelf restricts the data included in the view. For example, a Region filter can limit a sales table to selected regions.

Show Me

Show Me provides chart and visualization options based on the selected fields. It can help create a text table quickly when the selected dimensions and measures are suitable.

6. Step-by-Step: Creating a Basic Text Table

In this example, create a text table that displays sales by product category.

Step 1: Open Tableau

Launch Tableau Desktop or a supported Tableau authoring environment.

Step 2: Connect to a Dataset

Connect to a data source such as an Excel workbook, CSV file, database, or Tableau's Sample - Superstore dataset.

Step 3: Open a Worksheet

Create a new worksheet and locate the Data pane.

Step 4: Add a Dimension to Rows

Drag Category from the Data pane to the Rows shelf. Tableau creates a row for each category.

Step 5: Add a Measure to Text

Drag Sales to Text on the Marks card. Tableau typically displays SUM(Sales) for each category.

Step 6: Review the Results

Check the category names and sales values. Confirm that the aggregation matches the reporting requirement.

Step 7: Format the Values

Format Sales as currency or another appropriate number format. Adjust the font, alignment, and table layout if necessary.

Step 8: Rename the Worksheet

Give the worksheet a descriptive name, such as Sales by Category.

Expected Result

Note: The values above are illustrative. Actual results depend on the dataset and filters used.

7. Step-by-Step: Creating a Crosstab

Now create a crosstab showing sales by region and category.

Step 1: Add Region to Rows

Drag Region to the Rows shelf to create one row for each region.

Step 2: Add Category to Columns

Drag Category to the Columns shelf. Tableau creates a separate column for each category.

Step 3: Add Sales to Text

Drag Sales to Text on the Marks card. Tableau displays the aggregated sales value at the intersection of each region and category.

Step 4: Review the Crosstab

Check that every row corresponds to the correct region and every column corresponds to the correct category.

Step 5: Format the Numbers

Format Sales as currency, apply readable number formats, and adjust the column widths.

Step 6: Add Totals if Required

Use the Analysis menu and its Totals options to display row totals, column totals, or grand totals when supported by the view.

Typical Field Placement

8. Creating a Text Table Using Show Me

Show Me can help create a text table without manually configuring every part of the view.

Procedure

1. Open a worksheet connected to your dataset.
2. Select a dimension such as Category.
3. Select a measure such as Sales.
4. Open Show Me.
5. Select the text table option when available.
6. Inspect the generated table and its Marks card.
7. Move fields to Rows, Columns, or Text as required.
8. Format the table and verify the aggregation.

Tip: Show Me is a starting point, not a replacement for understanding the table's field arrangement. Review the generated view to ensure it answers the intended business question.

9. Creating a Crosstab with Dates

Text tables can organize values across years, quarters, months, or exact dates.

Example: Annual Sales by Category

1. Drag Order Date to Columns.
2. Choose Year as the required date level.
3. Drag Category to Rows.
4. Drag Sales to Text on the Marks card.
5. Review the annual sales values for each category.
6. Format the measure as currency.

Example Output

Important: Select a date level that matches the question. Year is suitable for long-term comparisons, while month is more appropriate for detailed monthly reporting.

10. Creating a Crosstab with Multiple Measures

A text table can display more than one measure, such as Sales, Profit, Quantity, and Discount.

Method 1: Add Multiple Measures to Text

1. Create a text table using dimensions such as Region and Category.
2. Drag Sales to Text on the Marks card.
3. Drag another measure, such as Profit, to the view.
4. Inspect the Marks card to see how Tableau arranges the measures.
5. Use Measure Names and Measure Values if you need to organize several measures systematically.

Method 2: Use Measure Names and Measure Values

1. Drag Region to Rows.
2. Drag Measure Names to Columns or Rows, depending on the desired layout.
3. Drag Measure Values to Text on the Marks card.
4. Use the Measure Values card to include only the measures you want to display.
5. Format each measure appropriately.

Example Output

Important: The example values are illustrative. Different measures may require different number formats, such as currency for Sales and Profit and whole numbers for Quantity.

11. Understanding Measure Names and Measure Values

Measure Names and Measure Values are special Tableau fields that help organize multiple measures in a single view.

Measure Names

Measure Names represents the names of the measures available in the data source. It can be used to distinguish measures such as Sales, Profit, and Quantity.

Measure Values

Measure Values represents the values of the selected measures. It allows multiple measures to be displayed in a common view.

Example

Suppose you want a table with Region in the rows and Sales, Profit, and Quantity as separate measure columns.

• Place Region on Rows.
• Place Measure Names on Columns.
• Place Measure Values on Text.
• Filter Measure Names or adjust Measure Values to include the required measures.

This arrangement is useful when the report must compare multiple metrics for the same dimension.

12. Sorting Text Tables and Crosstabs

Sorting helps users find the largest values, smallest values, and most important categories quickly.

Sorting by Category Name

Use the sort options for the dimension to arrange category names alphabetically or in reverse alphabetical order.

Sorting by Sales

1. Select the relevant dimension in the view.
2. Use the sort controls or open the field's sort options.
3. Choose sorting by a field or measure when available.
4. Select Sales and the desired aggregation, such as SUM(Sales).
5. Choose ascending or descending order.

Sorting Best Practices

• Sort categories by their business importance when appropriate.
• Use descending order to display the highest values first.
• Preserve chronological order for date fields.
• Avoid alphabetical sorting when it obscures a meaningful numerical ranking.
• Keep sorting consistent across related worksheets.

13. Formatting Numbers in Text Tables

Number formatting improves readability and helps users interpret values correctly.

Currency Formatting

Use currency formatting for Sales, Profit, Revenue, and Expenses when the values represent monetary amounts.

Percentage Formatting

Use percentage formatting for profit margin, discount rate, growth rate, and percentage of total.

Whole Number Formatting

Use whole-number formatting for counts and quantities when decimal values are not meaningful.

Decimal Formatting

Use decimal places for measures that require precision, such as averages, rates, or measurements.

Typical Procedure

1. Right-click the measure in the Data pane or select the relevant measure in the view.
2. Open the formatting or default number-format options available in your Tableau version.
3. Choose the appropriate format, such as Number, Currency, or Percentage.
4. Set the desired decimal places and display units.
5. Check that the formatting is consistent throughout the report.

Best Practice: Avoid displaying too many decimal places when they do not provide useful information. Make sure values remain precise enough for the intended business purpose.

14. Adding Row Totals, Column Totals, and Grand Totals

Totals summarize the values across rows or columns and make it easier to understand the overall result.

Row Totals

Row totals summarize the values across a row. For example, a row total can display the total sales for a region across all product categories.

Column Totals

Column totals summarize values down a column. For example, a column total can show total sales for Technology across all regions.

Grand Totals

Grand totals summarize the entire table. They provide an overall total for the measure represented in the view.

How to Add Totals

1. Build a text table or crosstab containing the required dimensions and measure.
2. Open the Analysis menu.
3. Choose Totals and review the available options.
4. Enable the required row totals, column totals, or grand totals.
5. Inspect the results to confirm that the totals represent the intended aggregation.

Available options can vary depending on the view and the Tableau version.

Example

15. Calculating Percentage of Total in a Crosstab

Percentage of total shows how much each value contributes to a specified total. It is useful for comparing category contributions, regional sales shares, and other proportions.

Formula

Percentage of Total = (Individual Value / Relevant Total) × 100

Example

If a region generates ₹40,000 in sales out of a total of ₹1,00,000, the percentage of total is:

(40,000 / 1,00,000) × 100 = 40%

Using a Quick Table Calculation

1. Create a crosstab with the required dimensions and a measure such as Sales.
2. Open the menu for the measure used in the view.
3. Select Add Table Calculation or Quick Table Calculation, depending on the interface.
4. Choose Percent of Total.
5. Configure the calculation direction, such as Table (Down), Table (Across), Pane (Down), or Pane (Across), according to the layout and intended denominator.
6. Format the result as a percentage.
7. Verify the result against the expected total.

Important: The calculation direction matters. A percentage calculated down a column may answer a different question from a percentage calculated across a row. Always verify what the 100% represents.

16. Adding Color to a Text Table

Color can emphasize values and make a text table easier to interpret. For example, a high-profit value might be highlighted differently from a low-profit value.

Procedure

1. Create a text table with the required dimensions and measure.
2. Drag the relevant measure, such as Profit, to Color on the Marks card.
3. Choose a suitable color palette.
4. Review the color legend.
5. Adjust the color range and formatting when supported and appropriate.

When color is added to a text table, the view can become a highlight table, depending on the mark configuration.

Color Best Practices

• Use color to highlight meaningful differences, not simply to decorate the table.
• Choose accessible colors with sufficient contrast.
• Use sequential color scales for values that increase from low to high.
• Use diverging color scales when values meaningfully cross a midpoint, such as zero profit.
• Keep the legend visible when the color scale requires explanation.

17. Difference Between Text Tables and Highlight Tables

A text table emphasizes values displayed as text. A highlight table adds color to the cells to make patterns or important values easier to notice.

Use a plain text table when users need exact numbers. Use a highlight table when users need to identify high and low values quickly while retaining the numerical details.

18. Creating a Text Table with Filters

Filters allow users to focus on a specific subset of the data.

Example: Sales by Category for a Selected Region

1. Create a text table with Category on Rows and Sales on Text.
2. Drag Region to the Filters shelf.
3. Select the required region.
4. Show the filter if users need to change the selection.
5. Add an Order Date filter if the report should be limited to a selected period.
6. Test the filters and confirm that the displayed values update correctly.

Useful Filters

19. Creating a Crosstab for Monthly Sales

A monthly sales crosstab allows users to compare performance across months and categories.

Procedure

1. Drag Category to Rows.
2. Drag Order Date to Columns.
3. Choose Month at the appropriate date level.
4. Drag Sales to Text on the Marks card.
5. Format the values as currency.
6. Adjust column widths so the month headings are readable.
7. Sort categories as required.
8. Add totals when they improve the analysis.

Business Questions

• Which category generates the highest sales in each month?
• Which months have the highest or lowest sales?
• How does category performance change over time?
• Are there unusual differences between periods?

Tip: Ensure the date configuration preserves the year when the view spans multiple years. Otherwise, January from different years may be grouped together when a month date part is used.

20. Creating a Crosstab with Profit and Sales

A crosstab with multiple measures helps compare different business metrics side by side.

Procedure

1. Place Region on Rows.
2. Place Category on Columns, if that arrangement suits the report.
3. Use Measure Names and Measure Values to include both Sales and Profit.
4. Configure the layout to make the measures easy to distinguish.
5. Format Sales and Profit as currency.
6. Inspect the table for missing values and unexpected aggregation.

For a complex report, consider putting the measures into separate columns or using separate worksheets if a single table becomes too wide or difficult to read.

21. Exporting Text Tables and Crosstabs

Text tables are often used in reports that require sharing, reviewing, or further analysis in other applications.

Common Export Options

• CSV: Useful for tabular data that will be analyzed in spreadsheets or other tools.
• Excel: Useful when the output needs to be reviewed or processed in a spreadsheet.
• PDF: Useful for reports that need to preserve a presentation-oriented layout.
• Image: Useful when a table needs to be included in a presentation or document as a visual.

General Procedure

1. Open the worksheet or view you want to export.
2. Open the relevant Download, Export, or Worksheet menu for your Tableau environment.
3. Select an available export format.
4. Review the export options and complete the export.
5. Open the exported file and verify the values, layout, and completeness.

Note: Available export options depend on the Tableau product, permissions, and view type. Exporting the crosstab data is not always the same as exporting a screenshot or formatted report.

22. Common Problems and Solutions

23. Practical Project: Regional Sales Crosstab Dashboard

Project Objective: Build a Tableau dashboard containing a sales crosstab with regional and category summaries, totals, filters, and useful formatting.

Required Fields

• Region
• Category
• Sub-Category
• Order Date
• Sales
• Profit
• Quantity

Part A: Build the Crosstab

1. Connect to the Sample - Superstore dataset or a similar sales dataset.
2. Open a new worksheet.
3. Drag Region to Rows.
4. Drag Category to Columns.
5. Drag Sales to Text on the Marks card.
6. Format the values as currency.
7. Rename the worksheet Regional Sales Crosstab.

Part B: Add Additional Measures

1. Use Measure Names and Measure Values to include Sales, Profit, and Quantity.
2. Arrange the fields so the measures are easy to compare.
3. Format each measure appropriately.
4. Check that the values use the intended aggregations.

Part C: Add Totals

1. Open the Analysis menu.
2. Review the Totals options.
3. Enable appropriate row, column, or grand totals.
4. Verify that the displayed totals agree with the underlying measure aggregation.

Part D: Add Filters

1. Add Order Date to Filters.
2. Add Region or Segment filters if required.
3. Show the filters for interactive analysis.
4. Test different filter selections.

Part E: Create a Dashboard

1. Create a new dashboard.
2. Add the regional sales crosstab.
3. Add a sales-by-category bar chart for visual comparison.
4. Add the relevant filters.
5. Use a clear dashboard title and readable layout.
6. Test the dashboard before sharing it.

Expected Outcome

The dashboard should allow users to inspect exact sales values, compare regions and categories, review totals, and filter the report by date or segment.

Business Questions

• Which region has the highest total sales?
• Which category contributes the most sales in each region?
• How does profit compare with sales?
• Which categories have low or negative profit?
• How do the results change when a different date range is selected?

24. Best Practices for Text Tables and Crosstabs

• Use descriptive row and column headers.
• Place dimensions on Rows and Columns to create a clear structure.
• Place the required measures on Text or use Measure Names and Measure Values for multiple measures.
• Choose the correct aggregation for every measure.
• Use suitable currency, percentage, date, and decimal formats.
• Sort categories to support the intended comparison.
• Use totals when they provide useful context.
• Keep the number of rows and columns manageable.
• Use filters to focus the analysis.
• Apply color only when it adds meaning.
• Use highlight tables when color can reveal patterns in the values.
• Keep labels and headers readable.
• Use charts alongside tables when trends or comparisons need to be understood quickly.
• Verify totals and percentages before publishing the report.

25. Interview Questions and Answers

Q1. What is a text table in Tableau?

Answer: A text table displays data in rows and columns, using text and numerical values. It is useful when users need to inspect exact values and summarized results.

Q2. What is a crosstab?

Answer: A crosstab organizes summarized values across combinations of dimensions. For example, it can show sales by region in rows and product categories in columns.

Q3. What is the difference between a text table and a crosstab?

Answer: The terms are often interchangeable in Tableau. A text table is the general tabular view, while a crosstab commonly emphasizes cross-classification by multiple dimensions.

Q4. How do you create a text table in Tableau?

Answer: Place a dimension on Rows and drag a numerical measure to Text on the Marks card. Add other dimensions or measures as required.

Q5. How do you create a crosstab with regions and categories?

Answer: Place Region on Rows, Category on Columns, and Sales on Text. Tableau displays sales for each region-category combination.

Q6. What is the Marks card used for?

Answer: The Marks card controls how data is represented in the view, including mark type, text, color, size, detail, and tooltips.

Q7. What are Measure Names and Measure Values?

Answer: Measure Names represents the names of the measures, while Measure Values represents the values of the selected measures. They help display multiple measures in a single view.

Q8. How can you display multiple measures in a crosstab?

Answer: Use Measure Names and Measure Values to organize the selected measures, or add measures to the view and configure their placement on the Marks card.

Q9. How do you add grand totals?

Answer: Open the Analysis menu, review the Totals options, and enable the appropriate grand-total or row-and-column-total settings available for the view.

Q10. How do you calculate percentage of total?

Answer: Use a Percent of Total table calculation and configure its calculation direction and scope to match the intended denominator.

Q11. What is a highlight table?

Answer: A highlight table displays values in cells and uses color to emphasize differences or patterns.

Q12. How do you sort a text table by sales?

Answer: Use the dimension's sort options and select the Sales measure and appropriate aggregation, such as SUM(Sales), as the sorting field.

Q13. Why might a text table display unexpected totals?

Answer: Possible causes include an incorrect aggregation, duplicate records, unexpected dimensions in the view, or an unsuitable calculation scope.

Q14. When should you use a text table instead of a chart?

Answer: Use a text table when users need exact values, detailed records, or structured summaries. Use charts when trends, distributions, and relationships need to be understood quickly.

Q15. Can text tables be used in dashboards?

Answer: Yes. Text tables and crosstabs can be combined with charts, filters, and other worksheets to create interactive reporting dashboards.

26. Practice Exercises

Exercise 1: Sales by Category

Create a text table showing total sales for each product category. Sort the categories by sales from highest to lowest.

Exercise 2: Sales by Region and Category

Create a crosstab with Region on Rows, Category on Columns, and Sales on Text.

Exercise 3: Annual Sales Comparison

Create a table displaying annual sales by category. Identify the category with the highest sales in each year.

Exercise 4: Multiple Measures

Create a crosstab containing Sales, Profit, and Quantity. Format each measure appropriately.

Exercise 5: Percentage of Total

Add a Percent of Total calculation to a crosstab. Explain whether the percentages are calculated across rows, down columns, or within panes.

Exercise 6: Add Totals

Enable row totals, column totals, and grand totals where appropriate. Check the results against the underlying data.

Exercise 7: Create a Highlight Table

Add color based on Sales or Profit and explain what the color scale represents.

Exercise 8: Build an Interactive Dashboard

Create a dashboard with a crosstab, a supporting bar chart, and date or region filters.

27. Quick Revision Notes

• Text Table: Displays data values in rows and columns.
• Crosstab: Summarizes values across combinations of dimensions.
• Rows Shelf: Defines the row headers.
• Columns Shelf: Defines the column headers.
• Marks Card: Controls the display of marks and their visual properties.
• Text: Displays measure values within cells.
• Dimensions: Categorize or describe the data.
• Measures: Provide numerical values for analysis.
• Measure Names: Identifies the measures used in the view.
• Measure Values: Provides the values of selected measures.
• Totals: Summarize values across rows, columns, or the whole table.
• Percentage of Total: Displays a value's contribution to a defined total.
• Highlight Table: Uses color to emphasize differences between cells.
• Filters: Restrict the records included in the view.
• Best Practice: Keep the table readable and verify aggregations and calculations.

28. Final Checklist

• Understand the purpose of text tables and crosstabs.
• Connect to the correct dataset.
• Identify the dimensions and measures required.
• Place dimensions on the appropriate Rows and Columns shelves.
• Place the required measure on Text.
• Verify measure aggregation.
• Format currency, percentages, dates, and decimals correctly.
• Sort values appropriately.
• Add totals when useful.
• Configure percentage calculations correctly.
• Use color when it communicates meaningful information.
• Add and test filters.
• Check for missing values and unexpected totals.
• Test the worksheet or dashboard before sharing.

29. Conclusion

Text tables and crosstabs are important Tableau tools for displaying exact values and organizing detailed business data. By placing dimensions on Rows and Columns and measures on Text, you can create tables that summarize sales, profit, quantity, and other metrics.

Advanced techniques such as Measure Names and Measure Values, percentage-of-total calculations, totals, filters, sorting, and color formatting make these tables more useful for business reporting. Combine them with charts when users need both precise numbers and a quick visual understanding of trends or comparisons.

Learn More

• JustAcademy Tableau Training
• Register for a Tableau Course Demo
• Official Tableau Help: Build a Text Table
• Tableau: Understanding and Using Text Tables
• Official Tableau Help: Tips for Working with Your Data