How to Apply Quick Table Calculation in Tableau

While working on Tableau reports and charts, I often need to calculate percentages or running totals. We can perform these advanced calculations without creating a calculated field.

In Tableau, there is a built-in Quick table calculation that allows us to perform advanced calculations like Running Total, Percent of Total, and Rank with clicks.

In this tutorial, I will explain what Quick Table Calculations are in Tableau and how to apply them in Tableau worksheets.

Quick Table Calculation in Tableau

In Tableau, Quick Table Calculations are pre-built calculations that allow us to implement calculations for the measures that we have used in the Tableau charts and tables. Instead of manually creating formulas, we can right-click on a measure and apply built-in options such as:

  • Running Total
  • Percent of Total
  • Difference
  • Percent Difference
  • Rank
  • Moving Average
  • Percentile
  • Year-over-Year Growth

Apply Quick Table Calculation in Tableau

In the examples below, we will see the method to apply the built-in quick table calculation for different scenarios using the Tableau Superstore dataset.

Example-1: Showing Percent of Total Sales by Region

In this example, we will show the sales total in percentage for the regions in the Superstore dataset.

To create the view, drag the Region to Rows and Sales to Columns.

Create a Quick table calculation in Tableau

To see the percentage of the total, add Sales to the Label cards in the Marks section. Then, click on the sales label and select Quick Table Calculation -> Percent of Total.

Percent of total in Tableau

Now, on the bar labels, we can see the percentage contribution of each region to the total sales.

Percentage of total sales in Tableau

This way, we can use the quick table calculation in Tableau to show the percentage of the total.

Example-2: Creating a Running Total of Sales Over Months

In this example, we will display the running total of sales using the Quick table calculation. With this calculation, we can analyze the sales of months over the years.

To create the view, add the Order date to the Columns and set the date format to Months.