Show Table of Contents
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:
Transforming values to rankings
Transforming values to show running totals
Transforming values to show percent of total
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).
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.
Highlighting shows you the scope of your calculation by setting off part of the view with a colored background as you change the Compute Using option in the Table Calculation dialog box:
If you select a different mark in the view while the Table Calculations dialog box is still open, highlighting will switch to the partition containing that mark.
Running Order Labels are numbers, displayed in square brackets, that indicate how the current calculation is moving through a partition. If you have ever used the INDEX() function to help you visualize a table calculation, running order labels provide the same insight.