Quick table calculations allow you to quickly apply a common table calculation to your visualization using the most typical settings for that calculation type.

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 of year growth
  • YTD growth

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.
  2. Navigate to a new worksheet.
  3. From the Data pane, under Dimensions, drag Order Date to the Columns shelf.
  4. From the Data pane, under Dimensions, drag State to the Rows shelf.
  5. From the Data pane, under Measures, drag Sales to Text on the Marks Card.
  6. From the Data pane, under Measures, drag Profit to Color on the Marks Card.
  7. On the Marks card, click the Mark Type drop-down and select Square.