Why table calculations compute across the view in Tableau - Why Use It

Introduction

Table calculations in Tableau perform their computations based on the data visible in the current view. This means they use the data already displayed in your worksheet to calculate results, which helps you analyze trends or differences within that specific view.

When you want to calculate running totals or moving averages based on the data shown in your chart.

When you need to compare each value to the total of all values currently displayed.

When you want to rank items within the visible data on your worksheet.

When you want to calculate percent differences between values shown in your view.

When you want to perform calculations that depend on the order or layout of data in the current visualization.

Steps

Step 1: Open your Tableau workbook and go to the worksheet with your data view

- Tableau workspace

You see your data displayed in rows and columns or as a chart

💡 Make sure your data is arranged the way you want to analyze it

Step 2: Click the drop-down arrow on a measure in the view

- Columns or Rows shelf

A menu appears with calculation options

💡 You can also right-click the measure in the data pane

Step 3: Select 'Add Table Calculation' from the menu

- Measure drop-down menu

The Table Calculation dialog box opens

💡 This dialog lets you choose how the calculation computes across the view

Step 4: Choose the calculation type (e.g., Running Total, Percent of Total)

- Table Calculation dialog box

The calculation type is applied to the measure

💡 Pick the calculation that fits your analysis goal

Step 5: Set the 'Compute Using' option to define how the calculation moves across the view

- Table Calculation dialog box under 'Compute Using'

Tableau calculates the result based on the selected direction (e.g., Table Across, Table Down)

💡 This controls whether the calculation goes across columns, down rows, or uses a custom path

Step 6: Click OK to apply the table calculation

- Table Calculation dialog box

The view updates showing the calculated results based on the visible data

💡 You can adjust the view or calculation settings to see different results

Before vs After

Before

The view shows sales numbers for each region and month without any calculations

After

The view shows running totals of sales for each region across months, calculated based on the visible data

Settings Reference

Calculation Type

📍 Table Calculation dialog box

Defines the type of table calculation to perform on the data in the view

Default: Running Total

Compute Using

📍 Table Calculation dialog box

Controls the direction and scope of the calculation across the data in the view

Default: Table Across

Restarting Every

📍 Table Calculation dialog box (for some calculations)

Determines if the calculation restarts at certain points in the view

Default: None

Common Mistakes

Expecting table calculations to use data not shown in the current view

Table calculations only compute based on the data currently visible in the worksheet

Adjust the view to include all necessary data before applying the table calculation

Choosing the wrong 'Compute Using' direction

This causes the calculation to aggregate data incorrectly across rows or columns

Select the correct direction (e.g., Table Across or Table Down) that matches how your data is arranged

Summary

Table calculations compute results based on the data visible in the current Tableau view.

You control how calculations move across the view using the 'Compute Using' setting.

Make sure your view includes all data needed before applying table calculations.