What Does Duplicate as Crosstab Mean in Tableau?

Ever polished a perfect chart in Tableau, only to have a colleague ask, "This is great, but can I see the numbers in a table?" That's a common request, and while you could build a new worksheet from scratch, there's a much faster and more accurate way. The "Duplicate as Crosstab" feature is your one-click solution to turn any visualization into a clean, text-based report. This article will show you exactly what it does, how to use it, and why it's one of the most practical time-savers in your Tableau toolkit.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

So, What Exactly Is a Crosstab?

Before diving into the feature itself, let's quickly clarify what a "crosstab" is. You probably already know it by another name: a text table, a pivot table, or simply, a data grid. A crosstab (short for cross-tabulation) is a table that displays the relationship between two or more variables.

Imagine you're analyzing sales data. A crosstab might show a list of product categories down the first column (the rows) and different regions across the top row (the columns). The cells where the rows and columns intersect would contain a measure, like the total sales amount for a specific category in a specific region.

Essentially, it’s a straightforward grid of numbers that presents data in a structured, easy-to-read format. While charts are great for spotting trends and outliers at a glance, crosstabs are perfect for looking up specific values and seeing the raw data behind the visuals.

Understanding "Duplicate as Crosstab" in Tableau

The "Duplicate as Crosstab" command does exactly what its name suggests. It takes an existing worksheet - with all its data, filters, calculated fields, and parameters - and creates a brand-new worksheet in the form of a crosstab.

Here’s what happens under the hood when you use it:

• It Leaves Your Original Chart Unchanged: Your source visualization remains completely untouched. The action creates a separate, new worksheet.
• It Creates a Perfect Data Replica: The new crosstab uses the exact same data source, filters, sets, and calculations from the original sheet. This is its biggest advantage, as it ensures 1:1 data parity between your visual and your table.
• It Rearranges Your Pills: Tableau intelligently takes the fields (the "pills") from your original chart's Marks card and shelves and reorganizes them. Dimensions are typically placed on the Rows and Columns shelves, and your primary measure is placed on the Text mark to populate the table.

Think of it as instantly translating a visual story (your chart) into a written manuscript (your table) without any details getting lost in translation.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step-by-Step: How to Use Duplicate as Crosstab

Using this feature is incredibly simple. It requires just a couple of clicks and zero dragging-and-dropping. Let's walk through it with a simple example.

Step 1: Build Your Original Visualization

First, create the chart you want to convert. For this example, let's imagine you've built a horizontal bar chart showing Profit by Sub-Category, filtered to only show the "Technology" category. You might have Sub-Category on Rows, SUM(Profit) on Columns, and a Category filter applied.

Step 2: Find Your Worksheet Tab

At the bottom of your Tableau workbook, you’ll see the tabs for each of your dashboards and worksheets. Locate the tab for the worksheet you just created (e.g., "Profit by Sub-Category").

Step 3: Right-Click and Select

Right-click on that worksheet tab. A context menu will appear with several options like "Rename," "Duplicate," "Delete," and the one we're looking for: Duplicate as Crosstab.

Step 4: See Your New Crosstab

Click "Duplicate as Crosstab," and Tableau will instantly create and open a new worksheet right next to the original. This new sheet will have a default name like "Profit by Sub-Category (2)". In this new sheet, you won't see bars anymore. Instead, you'll see a text table. Tableau has automatically done the following:

• Moved the Sub-Category pill to the Rows shelf.
• Moved the SUM(Profit) pill from the Columns shelf to the Text mark on the Marks card.
• Preserved the Category = "Technology" filter on the Filters shelf.

And that’s it! You now have a perfect table version of your chart, ready to be used in a dashboard or exported for someone who needs the raw numbers.

Why Use It? The Top Benefits

At this point, you might be thinking, "Cool, but I can build a table myself in 30 seconds." While that's true for simple charts, the benefits of "Duplicate as Crosstab" become more obvious as your workbooks grow in complexity.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

1. Incredible Speed and Efficiency

The most obvious advantage is speed. A single right-click is much faster than creating a new sheet, finding all the right dimensions and measures from your data pane, dragging them to the proper shelves, and re-applying the same filters, parameters, and calculations. When your original viz has multiple filters and complex table calculations, this feature can save you significant time and mental energy.

2. Guaranteed Data Consistency

This is arguably the most important benefit. Manually rebuilding a report introduces the possibility of human error. Did you forget to apply that one niche filter? Did you select the same date range? Are you using the same calculated field?

"Duplicate as Crosstab" eliminates these risks entirely. It algorithmically generates a copy, ensuring your table reflects the exact same data slice as your visualization. This builds trust and prevents those awkward meetings where the numbers in your chart don't match the numbers in your table.

3. Data Validation and Troubleshooting

Visualizations are great for highlighting trends, but sometimes you need to dig into the exact numbers. If a specific point on a line chart or a bar on a bar chart looks incorrect or surprisingly high, "Duplicate as Crosstab" is a fantastic debugging tool.

In two clicks, you can get a table view of the underlying data for that entire chart. This allows you to quickly inspect the numbers, sort them, and identify the specific records contributing to the unexpected result without breaking your primary visualization.

4. Catering to Diverse Audience Needs

Executives might love dynamic, visual dashboards, but your finance or operations teams often want to see raw numbers in a grid they can easily copy and paste. In a dashboard, you can provide the best of both worlds. You can have your main interactive charts, but also include a button or navigation link to jump to a "Details" dashboard that contains a clean crosstab view of the same data.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

"Duplicate as Crosstab" vs. "View Data"

New Tableau users often mix up "Duplicate as Crosstab" with the "View Data" feature. While they sound similar, their purpose and output are very different.

View Data

You can right-click on any mark (like a single bar, a point on a line, or a pie slice) in your visualization and select "View Data." This opens a temporary pop-up window showing the underlying rows of data that make up that specific mark.

• It’s Temporary: The window disappears when you close it.
• It’s Granular: It shows you the detailed source data, not an aggregated summary.
• It’s Not a Worksheet: You can't format it, customize it, or add it to a dashboard.

"View Data" is best for quick, on-the-fly data inspection of a specific part of your chart.

Duplicate as Crosstab

This action is performed at the worksheet level by right-clicking the worksheet's tab.

• It’s Permanent: It creates a full, new worksheet in your workbook.
• It’s Aggregated: It provides a summary table at the same aggregation level as your original visualization.
• It’s a Worksheet: You can edit it, format it, rename it, and add it to any dashboard or story.

"Duplicate as Crosstab" is for creating a persistent reporting asset that you intend to share or use elsewhere in your workbook.

Final Thoughts

In summary, "Duplicate as Crosstab" is an elegant, highly efficient Tableau feature designed to bridge the gap between visual analysis and traditional reporting. It allows you to create an accurate tabular representation of any visualization in seconds, ensuring data consistency and saving you from tedious manual work. It's a fundamental utility for data validation, audience accommodation, and rapid report creation.

While Tableau gives you the tools to create and replicate reports, managing dozens of dashboards and data sources can quickly become chaotic. That's why at Graphed , we simplified the entire process. Instead of needing to manually duplicate anything, you can just ask our AI data analyst what you need. Prompt it to "Show me last quarter's sales as a bar chart" and then follow up with "convert this to a table" to get what you need instantly. By connecting directly to your sources like Google Analytics, Shopify, and Salesforce, we help you get live answers and build shareable dashboards faster than ever before.