How to Create a Quarterly Sales by Territory Report in Tableau

Creating a quarterly sales by territory report reveals which regions are your top performers and which may need more support. This guide will walk you through building an interactive and insightful sales territory map in Tableau, step-by-step. We'll build a core map, filter it by quarter, and combine it with a trend chart to give you a complete picture of your regional performance.

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

First Things First: Prepping Your Sales Data

Before you can build anything in Tableau, you need clean, well-structured data. For a sales by territory report, your dataset should contain at least three key components:

• A Sales Metric: This is the number you want to measure, like 'Revenue', 'Sales Amount', or 'Units Sold'. This must be a numerical value.
• A Geographical Dimension: This is how you define your territories. It could be 'State', 'Country', 'Region', 'ZIP Code', or a custom territory name you've created.
• A Date Dimension: You need a date for each sale, such as an 'Order Date' or 'Close Date', so you can group your sales by quarter.

Your data source, whether it's a CRM export or a simple spreadsheet, might look something like this:

Before connecting this to Tableau, take a moment to clean it up. Ensure your geographical fields are consistent - for example, use "California" every time instead of mixing "California," "CA," and "Calif." Inconsistent naming will prevent Tableau from correctly mapping your data. Once your data is clean, connect it to Tableau by navigating to the "Connect to Data" screen and selecting your file type (e.g., Microsoft Excel).

Building the "By Territory" Map in Tableau

With your data connected, you can start building the map visualization. Tableau is incredibly smart about recognizing geographical data, so this part is surprisingly simple.

Step 1: Create the Basic Map

Find your geographic field (e.g., 'State') in the Data pane on the left side of the screen. Double-click it. Tableau will automatically identify the field as geographic data, place the 'Longitude' and 'Latitude' fields on the Columns and Rows shelves, and generate a map with a dot for each state in your dataset.

If Tableau doesn't create a map automatically, you may need to assign a geographic role manually. Right-click on your territory field in the Data pane, go to Geographic Role, and select the appropriate level (e.g., State/Province).

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 2: Add Your Sales Data to the Map

Your map shows where you have data, but it doesn't tell you anything about performance yet. To fix that, we’ll use color to represent sales volume.

• Find your sales metric (e.g., 'Revenue') in the Data pane.
• Drag the 'Revenue' field and drop it onto the Color card in the Marks pane.

Instantly, your map will transform into a filled map, with each territory shaded based on its total revenue. By default, Tableau uses a blue gradient where darker shades represent higher sales. You can customize this by clicking on the 'Color' card and selecting 'Edit Colors'.

Step 3: Add Labels for Clarity

Shading is great for getting a quick feel for performance, but seeing the actual numbers is even better. To add your sales totals as labels on the map:

• Drag your 'Revenue' metric from the Data pane onto the Label card in the Marks pane.
• You can also drag your 'State' dimension to the Label card to display the state's name as well.

Your map now shows the total sales for each territory directly on the screen, giving you and your audience at-a-glance information without needing to hover over each state.

Slicing Your Data By Quarter

You currently have a map showing total sales, but your goal is to see quarterly sales. To do that, we need to add a filter based on your date dimension.

Step 1: Drag Your Date Field to the Filters Shelf

Find your 'Order Date' field in the Data pane and drag it directly onto the Filters shelf. A dialog box will pop up, asking how you want to filter the date. For a quarterly report, select "Quarters" and click Next.

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

Step 2: Choose Your Quarters

Another dialog box will appear, listing all the unique Quarter/Year combinations in your dataset (e.g., Q1 2023, Q2 2023, etc.). You can select one or more quarters to display. For now, just click a few and press 'OK'. Your map will update to show sales only for the quarters you selected.

Pro-Tip: Make the filter interactive. A static report is good, but an interactive dashboard is better. Right-click on the 'Order Date' filter on your Filters shelf and select "Show Filter". A filter control card will appear on the right side of your view, allowing you or your stakeholders to select different quarters on the fly.

Adding a Trendline: Tracking Sales Over Time

A map is great for showing regional performance for a specific period, but what if you want to see if sales in a hot territory are trending up or down? Adding a line chart to complement your map gives you this historical context.

Step 1: Create a New Worksheet

Create a second view by clicking the "New Worksheet" icon at the bottom of the Tableau window (it looks like a small bar chart with a plus sign).

Step 2: Build the Line Chart

• Drag your 'Order Date' field from the Data pane onto the Columns shelf. By default, Tableau might show it as 'YEAR(Order Date)'. Right-click the blue pill on the shelf and select 'Quarter'. You'll want the second 'Quarter' option, which includes the year and is continuous (it shows a green icon).
• Next, drag your 'Revenue' field to the Rows shelf.

That's it! You now have a line chart that shows total company revenue quarter-over-quarter. This chart provides a bird's-eye view of your sales performance trends.

Putting It All Together on a Dashboard

Now it’s time to combine your map and your line chart into a single, cohesive dashboard that lets you explore your data.

Step 1: Create a New Dashboard

At the bottom of the window, next to the "New Worksheet" button, click the "New Dashboard" icon.

Step 2: Add Your Worksheets

On the left, you'll see a list of your worksheets. Simply drag your map sheet and your line chart sheet onto the blank dashboard canvas. Arrange them how you see fit, perhaps with the map taking up the top two-thirds and the line chart below it.

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 3: Make it Interactive

This is where the dashboards come to life. You can make it so that clicking on a state in your map automatically filters the line chart to show the trend for just that state. It's incredibly powerful and only takes a single click to set up.

• Select the map worksheet on your dashboard (a gray border will appear around it).
• In the top-right corner of the selected container, click the little funnel icon that says "Use as Filter".

Go ahead and try it out. Click on a specific state like 'California' on your map. You'll see the line chart below instantly update to show only California's quarterly sales trend. This simple action turns a static report into a dynamic exploratory tool for your whole team.

Finally, bring your 'Quarter' filter onto the dashboard. Click on one of your worksheet containers, hit the small dropdown arrow, and navigate to Filters > Quarter(Order Date). Now your filter card is visible on the dashboard and will control both the map and the line chart.

Tips for a Polished, Professional Report

Your dashboard is functional, but a few finishing touches can make it much more professional and easier to understand.

• Use Clear Titles: Double-click the title of your dashboard and give it a clear, descriptive name like "Quarterly Sales Performance by Territory." Do the same for your individual map and chart.
• Clean Up Your Tooltips: Hover over a state on your map. The default tooltip can be crowded. Click on the 'Tooltip' card in the Marks pane for your map worksheet and edit the text to be cleaner. For example, you can write something like "State: &lt,State&gt,", and "Total Sales in Period: $&lt,SUM(Revenue)&gt,".
• Organize and Size: Adjust the size of the elements on your dashboard so everything fits cleanly with no unnecessary scrollbars. Make sure important elements, like the map and interactive filters, are prominent.

Final Thoughts

You've seen how to prepare your sales data, build an insightful territory map, filter it by quarter, and combine it with a trend chart into an interactive dashboard. Mastering reports like this in Tableau is a valuable skill that gives decision-makers the evidence they need to lead effectively and pinpoint regional opportunities or challenges.

Building reports in tools like Tableau is powerful, but it often involves manual data prep, figuring out the right chart types, and maintaining dashboards. This is exactly where we've designed Graphed to simplify the process. Instead of working through multiple steps, you can just ask in plain English, "Show me a map of our sales by state for Q3," and get a live, interactive dashboard instantly. We connect directly to sources like Salesforce, HubSpot, or a simple Google Sheet, letting you go from raw data to actionable insights in seconds, not hours.