Tutorial Gateway

  • C
  • C#
  • Python
  • SQL
  • Java
  • JS
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • Alteryx
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Go Programs
    • Python Programs
    • Java Programs
  • MySQL

Tableau Running Total Calculation

In this article, we will show you how to calculate the Tableau Running Total with an example. For Tableau Running Total demo, we are going to use the Data Source we created in our previous article.

Please visit Data Labels in Tableau Reports article to understand the Tableau Data Source.

Calculate Tableau Running Total

Before we start calculating the running total in Tableau, let me create a tableau report that we are going to use in this example. First, Drag and Drop the order date (Year) from Dimension Region to Column Shelf.

Next, Drag and Drop the Order date (Quarter), and Order date (Month) from Dimension Region to Rows Shelf. Finally, Drag and Drop the Sales Amount from measures region to text filed present in the Marks shelf. Once you drag them, the following Table Report will generate.

Tableau Running Total Calculation 1

As you can see, we don’t have much data (sales) for the years 2010 and 2014. So, we are excluding those two years from the table report by selecting those two columns, and then clicking the exclude button present in the tooltip

Tableau Running Total Calculation 2

The below screenshot will show you the final report that we are going to use for calculating the running sum in Tableau.

Tableau Running Total Calculation 3

To calculate the running Total in Tableau, we have to add the table calculation. To do so, click Down arrow beside the Sales Amount measure (change as per requirement) will open the context menu.

From the list of available options, either you can select the Add Table Calculation option or Quick Table Calculation option. I suggest you use the Add Table Calculation option

Tableau Running Total Calculation 4

Once you click on the Add Table Calculation option, a new window called Table Calculation will open, as we have shown below. As you can see, by default, Tableau has selected the Calculation Type as Difference from, and Compute using option as Table (across).

Tableau Running Total Calculation 5

Please change the calculation type from Difference From option to Running Total

Tableau Running Total Calculation 6

Next, change the Computing using option from Table (across) to Table (down)

Tableau Running Total Calculation 7

As you can see, we have successfully generated the report that is calculating the running total in Tableau.

Tableau Running Total Calculation 8

I think it will be helpful to show the Sales Amount values. So that you can compare the Running Total with the Original Sales Amount values, let us add the Sales Amount to Columns Shelf.

As you can see, Tableau shows the Original values and its running Total for each year.

Tableau Running Total Calculation 9

Tableau Running Total for each Partition

It will be nice if we calculate the Running Total for each partition or each Quarter. To change the actual calculation, we have to edit it.

To edit the existing table calculation, please click on the down arrow beside the table calculation will open the context menu. Here you have to select the Edit Table Calculation option, as shown below.

Tableau Running Total Calculation 10

Once you click on the Edit Table Calculation option, a new window called Table Calculation will open. As you can see, tableau has selected the best possible options such as Calculation Type as Running Total, Aggregation as SUM, and Compute using option as Specified Dimensions (Quarter of Order date, and Month of Order Date) by default.

Here, you have to change the Restarting Every option from None to Quarter of Order date. It will ensure tableau to restart the running total for every quarter of the year.

Tableau Running Total Calculation 11

Now you can see the running total for each quarter

Tableau Running Total Calculation 12

Add Secondary Calculation in Tableau

Tableau allows us to add the secondary calculation to the report. It is beneficial to calculate further on top of the actual calculation. To do so, Please check the Add Secondary Calculation option, as shown below.

Tableau Running Total Calculation 13

Please leave all the default settings, and change the Secondary Calculation Type option from the Difference From to Percentage Difference From

Tableau Running Total Calculation 14

The following screenshot will show you the Percentage of difference in Tableau running total

Tableau Running Total Calculation 15

Filed Under: Tableau

  • Download and Install Tableau
  • Tableau Start Page
  • Tableau Show Me
  • Connect to MS Analysis Services
  • Connecting Tableau to SQL
  • Tableau Connect to Text File
  • Tableau Connect to Excel File
  • Hierarchies in Tableau
  • Tableau Bins
  • Tableau Parameters
  • Combined Tableau Sets
  • Tableau Set
  • How to Edit Tableau Group
  • Tableau Group
  • Tableau Grouping
  • Tableau First Report
  • Data Labels in Tableau Reports
  • Format Tableau Chart Title
  • Create Folders in Tableau
  • Tableau Sort
  • Add Totals in Tableau
  • How to Join Data in Tableau
  • Tableau Data Blending
  • Tableau Table Report
  • Tableau Crosstab Report
  • Tableau Annotations
  • Tableau Charts
  • Tableau Area Chart
  • Tableau Bar chart
  • Tableau Box Plot
  • Tableau Bubble Chart
  • Tableau Bullet Graph
  • Tableau Bump Chart
  • Tableau Circle Views
  • Tableau Dual Combination Chart
  • Tableau Dual Lines Chart
  • Tableau Funnel Chart
  • Tableau Traditional Funnel Chart
  • Tableau Gantt Chart
  • Tableau Grouped Bar Chart
  • Tableau Heat Map
  • Tableau Highlight Table
  • Tableau Histogram
  • Tableau Cumulative Histogram
  • Tableau Line Chart
  • Tableau Lollipop Chart
  • Tableau Pareto Chart
  • Tableau Pie Chart
  • Tableau Scatter Plot
  • Tableau Stacked Bar Chart
  • Tableau Text Label
  • Tableau Treemap
  • Tableau Word Cloud
  • Tableau Waterfall Chart
  • Tableau Individual Axis
  • Tableau Dual Axis
  • Tableau Blended Axis
  • Tableau Add Reference Lines
  • Tableau Add Reference Bands
  • Add Reference Distributions
  • Tableau Maps
  • How to Create a Map in Tableau
  • Use Google Maps in Tableau
  • Mapbox Maps as a Background
  • WMS Server Map as Background
  • Create a Tableau Dashboard
  • Format Dashboard Layout
  • Create Dashboard Device Prev
  • Tableau Dashboard Objects
  • Create a Tableau Story
  • Tableau Filters
  • Tableau Filters on Dimensions
  • Tableau Filters on Measures
  • Tableau Extract Filters
  • Tableau Dashboard Filters
  • Tableau Data Source Filters
  • Tableau Slicing Filters
  • Tableau Quick Filters
  • Tableau Context Filters
  • Tableau Top Filters
  • Tableau Table Calculations
  • Tableau Calculated Fields
  • Tableau Running Total
  • Tableau Rank Calculation Basic
  • Tableau Rank advanced calculate
  • Tableau Aggregate Functions
  • Tableau Conversion Functions
  • Tableau Case Function
  • Tableau Date Functions
  • Tableau If Function
  • Tableau Logical Functions
  • Tableau Math Functions
  • Tableau String Functions
  • Tableau Table Functions

Copyright © 2021ยท All Rights Reserved by Suresh.
About | Contact | Privacy Policy