---
schema_version: "1"
id: 6a301745b5a153f9d2639fbcaa25dba473d5153f57ce4efc61675523499f786b
title: Quick Table Calculations
collection: tableau
version: next
locale: en-us
portal_url: https://docs.salesforce.com/tableau/next/en-us/public/desktop/calculations_tablecalculations_quick.md
canonical_url: https://help.tableau.com/v0.0/public/desktop/en-us/calculations_tablecalculations_quick.htm
source_site: help.tableau.com
content_type: documentation
content_hash: 31f64b7542d69ddd2d5eb710cc4e1a9b02ba508638773cbc55d4cc8ef433d949
description: Apply quick table calculations to a visualization using common default settings.
---
[Skip to main content](#main-content)

# Quick Table Calculations

Quick table calculations allow you to quickly apply a common table calculation to your visualization using the most typical settings for that calculation type. This article demonstrates how to apply a quick table calculation to a visualization using an example.

The following quick table calculations are available in Tableau for you to use:

- Running total
- Difference
- Percent difference
- Percent of total
- Rank
- Percentile
- Moving average
- YTD total
- Compound growth rate
- Year over year growth
- YTD growth

For more information about some of these, see [Table Calculation Types](https://help.tableau.com/v0.0/public/desktop/en-us/calculations_tablecalculations_definebasic_runningtotal.htm).

## How does a quick table calculation differ from a table calculation?

Quick table calculations are table calculations that you can apply quickly to your visualization in Tableau. They are applied to the visualization with the most typical settings for the calculation type you choose so that you can continue on with your analysis. With traditional table calculations, you can apply the same settings, but you must apply them manually.

## Apply a quick table calculation to the visualization

Follow along with the steps below to learn how to apply a quick table calculation to a visualization.

### Set up the visualization

1. Open Tableau Desktop and connect to the **Sample-Superstore** data source, which comes with Tableau and navigate to a new worksheet.
2. From the **Data** pane, drag Order Date to the Columns shelf.
3. Drag State to the Rows shelf.
4. Drag Sales to Text on the Marks Card.
5. Drag Profit to Color on the Marks Card.
6. On the Marks card, click the Mark Type drop-down and select Square.
    
    ![Marks card dropdown.](/tableau/next/en-us/public/desktop/en-us/Img/quicktablecalc1.png)

The visualization updates to look like this:

![A heatmap with sales data by state and year.](/tableau/next/en-us/public/desktop/en-us/Img/quicktablecalc2.png)

### Apply the quick table calculation

1. On the Marks card, right-click SUM(Profit) and select Quick Table Calculation > Moving Average.
    
    **Note**: You can only perform quick table calculations on measures in the view.
    
    A delta symbol appears on the field to indicate that a quick table calculation is being applied to the field. The colors in the visualization update to show the moving average of profit across the years.

![Quick table calculation.](/tableau/next/en-us/public/desktop/en-us/Img/quicktablecalc3.gif)

### (Optional) Customize the quick table calculation

1. On the Marks card, right-click Sum(Profit) and select Edit Table Calculation.
2. In the dialog box that opens, you can configure the following options:

- The calculation type
- How to aggregate the values
- How to compute the calculation (how to address and partition the calculation)

For more information about these options, see [Table Calculation Types](https://help.tableau.com/v0.0/public/desktop/en-us/calculations_tablecalculations_definebasic_runningtotal.htm) and [The basics: addressing and partitioning](https://help.tableau.com/v0.0/public/desktop/en-us/calculations_tablecalculations.htm#Basics)

The visualization updates as you make changes to the calculation. Highlighting and numbering are used to demonstrate how the calculation is being computed. For example, in the following image, the calculation is being computed across the table, for each State.

![Table calculation dialog box.](/tableau/next/en-us/public/desktop/en-us/Img/quicktablecalc4.png)

If this setting is changed, the visualization and highlighting update to indicate the change.

![Table calculation dialog box.](/tableau/next/en-us/public/desktop/en-us/Img/quicktablecalc5.png)

## See Also

[Understanding Calculations: Table calculations](https://help.tableau.com/v0.0/public/desktop/en-us/calculations_calculatedfields_understand_types.htm#Table)

[Transform Values with Table Calculations](https://help.tableau.com/v0.0/public/desktop/en-us/calculations_tablecalculations.htm)

[Customize Table Calculations](https://help.tableau.com/v0.0/public/desktop/en-us/calculations_tablecalculations_custom.htm)