Was this page helpful?
Yes No
Have a comment? Please leave it here. Thanks for your feedback!
All Tableau Help > Tableau Help > 
Design Views and Analyze Data > Advanced Analysis > Transform Values with Table Calculations
Applies to: Tableau Desktop, Tableau Online, Tableau Public, Tableau Server

Transform Values with Table Calculations

A table calculation is a transformation you apply to the values for a measure in the view.

You can use table calculations for a variety of purposes, including:

Table calculations are available as you work with views in Tableau Desktop and also as you edit views in Tableau Server or Tableau Online.

Table calculations are a special type of calculated field that computes on the local data in Tableau. They are calculated based on what is currently in the view and do not consider any measures or dimensions that are filtered out of the view.

The “table” is determined by the dimensions in the view—not the tables in your data source. Also, a “table calculation” is an entirely different thing than a calculated field. For information on calculated fields, see Calculated Fields.

Note: By default, Tableau ignores discrete measures in the view when applying table calculations. If you want Tableau to consider a discrete measure in the view in table calculations, click the field and choose Ignore in Table Calculations to remove the check mark (that is, to deselect it).

Calculation Assistance

Tableau provides visual cues to help you understand the effects of your decisions as you work with table calculations. You can toggle these aides on or off by clicking Show calculation assistance in the Table Calculation dialog box.

What is a Table Calculation?

Quick Table Calculations

Choose Your Approach to Table Calculations

Create a Table Calculation

Table Calculation Types

Customize Table Calculations