Why Running total in Tableau? - Purpose & Use Cases

The Big Idea

What if you could see your sales adding up automatically, without lifting a finger?

The Scenario

Imagine you have a long list of daily sales numbers in a spreadsheet. You want to see how sales add up over time, but you have to add each day's sales to the total of all previous days by hand.

The Problem

Doing this manually is slow and tiring. You might make mistakes adding numbers, especially if the list is long. Every time new data comes in, you have to redo all the sums again.

The Solution

Using a running total in Tableau automatically adds each value to the sum of all previous values. It updates instantly when data changes, saving time and avoiding errors.

Before vs After

✗ Before

Day 1: 100
Day 2: 100 + 150 = 250
Day 3: 250 + 200 = 450

✓ After

RUNNING_SUM(SUM([Sales]))

What It Enables

It lets you quickly see how numbers build up over time, helping you spot trends and make better decisions.

Real Life Example

A store manager tracks daily sales to see how revenue grows during a promotion, adjusting strategies based on the running total.

Key Takeaways

Manual addition is slow and error-prone.

Running total automates cumulative sums instantly.

It helps visualize growth and trends over time.