#### Overview of this book

Learning Tableau 10 Second Edition
Credits
www.PacktPub.com
Preface
Free Chapter
Creating Your First Visualizations and Dashboard
Working with Data in Tableau
Moving from Foundational to More Advanced Visualizations
Using Row-Level, Aggregate, and Level of Detail Calculations
Table Calculations
Formatting a Visualization to Look Great and Work Well
Telling a Data Story with Dashboards
Deeper Analysis – Trends, Clustering, Distributions, and Forecasting
Making Data Work for You
Advanced Visualizations, Techniques, Tips, and Tricks

## Scope and direction

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...