Scope and direction are terms that describe how a table calculation is computed relative to the table. When a table calculation is relative to the layout of the table, rearranging the fields in the view will not change the scope and direction.

• Scope: The scope defines the boundaries within which a given table calculation can reference other values
• Direction: The direction defines how the table calculation moves within the scope

You've already seen table calculations being calculated Table (across) (for example, the running sum of Sales over time) and Table (down) (for example, the preceding table ). In these cases, the scope was the entire table and the direction was either across or down. You may recall that the running total calculation ran across the entire table, adding subsequent values as it moved.

To define scope and direction for a table calculation, use the drop-down menu for the field in the view and select Compute Using. You will get a list of options that will vary slightly depending on the dimensions present in the view. The first few options that are listed allow you to define the scope and direction relative to the table. After the option for Cells, you will see a list of dimensions present in the view; we'll take a look at those in the next section.

In order to understand these options, consider the following example:

When it comes to the scope of table calculations, Tableau makes the following distinctions:

• The Table is the entire set of aggregate data.
• The Pane is defined by the next-to-second lowest level of the table (that is, the next-to-last dimension on the Rows and/or Columns shelf). In the preceding screenshot, you can see that the intersection of Year on Rows and Region on Columns defines the panes (one is highlighted, but there are actually eight in the view).
• The cell is defined by the lowest level of the table. In this view, the intersection of one Department within a Region and one Quarter within a Year is a single cell (one is highlighted, but there are actually 96 in the view).