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.
Note: 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.
Tableau 10 provides some key enhancements to the experience of creating table calculations:
As you work in the Table Calculation dialog box to configure a calculation, the view updates in real time to show the results of your choices.
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.