0
0
Tableaubi_tool~5 mins

Running total in Tableau - Step-by-Step Guide

Choose your learning style9 modes available
Introduction
A running total adds up values step-by-step across a sequence, like days or months. It helps you see how numbers grow over time, such as cumulative sales or expenses.
When you want to show total sales accumulating month by month in a sales report.
When tracking total website visitors adding up day after day.
When analyzing how expenses build up over a project timeline.
When comparing cumulative revenue between different products over quarters.
When you need to display progress toward a yearly goal as data accumulates.
Steps
Step 1: Open your Tableau workbook and go to the worksheet with your data
- Tableau workspace
You see your data fields and current visualization on screen
Step 2: Drag the measure you want to accumulate (e.g., Sales) to the Rows or Columns shelf
- Data pane and Rows or Columns shelf
A basic chart or table with the measure appears
Step 3: Right-click the measure pill on the shelf and select 'Quick Table Calculation'
- Measure pill on Rows or Columns shelf
A menu opens with calculation options
Step 4: Click 'Running Total' from the Quick Table Calculation menu
- Quick Table Calculation submenu
The chart updates to show the running total of the measure
Step 5: Click the measure pill again and select 'Edit Table Calculation' to adjust settings
- Measure pill context menu
The Table Calculation dialog opens for customization
💡 Use this to change the direction of accumulation or partitioning fields
Step 6: Set the calculation to compute using the correct dimension (e.g., Date) in the dialog
- Table Calculation dialog under 'Compute Using'
Running total calculates correctly along the chosen dimension
Before vs After
Before
A bar chart showing sales for each month separately, e.g., Jan: 1000, Feb: 1200, Mar: 900
After
A line chart showing cumulative sales by month, e.g., Jan: 1000, Feb: 2200, Mar: 3100
Settings Reference
Quick Table Calculation
📍 Right-click measure pill on Rows or Columns shelf
Apply common calculations quickly to measures
Default: None
Edit Table Calculation
📍 Right-click measure pill > Edit Table Calculation
Customize how the running total computes across dimensions
Default: Table Across
Common Mistakes
Not setting the correct dimension for the running total calculation
The running total sums data in the wrong order or across wrong categories, giving incorrect results
Use 'Edit Table Calculation' to select the proper dimension like Date or Category for accumulation
Applying running total on aggregated data instead of raw data
The calculation may double count or miss values if data is pre-aggregated incorrectly
Apply running total on the base measure before other aggregations or filters
Summary
Running total adds values step-by-step to show cumulative progress.
Use Quick Table Calculation > Running Total to apply it easily.
Always check and set the correct dimension for accurate results.