Bird
Raised Fist0
Tableaubi_tool~10 mins

Custom table calculation scope in Tableau - Cell-by-Cell Formula Trace

Choose your learning style10 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash

Start learning this pattern below

Jump into concepts and practice - no test required

or
Recommended
Test this pattern10 questions across easy, medium, and hard to know if this pattern is strong
Sample Data

Sales data by Region and Category

CellValue
A1Region
B1Category
C1Sales
A2East
B2Furniture
C2100
A3East
B3Office Supplies
C3150
A4East
B4Technology
C4200
A5West
B5Furniture
C5120
A6West
B6Office Supplies
C6180
A7West
B7Technology
C7220
Formula Trace
WINDOW_SUM(SUM([Sales]))
Step 1: SUM([Sales]) for each row
Step 2: WINDOW_SUM(SUM([Sales])) over entire table
Step 3: WINDOW_SUM(SUM([Sales])) partitioned by Region
Step 4: WINDOW_SUM(SUM([Sales])) partitioned by Region and Category
Cell Reference Map
    A       B               C
1 |Region | Category      | Sales
2 | East  | Furniture    | 100  
3 | East  | Office Supplies | 150  
4 | East  | Technology   | 200  
5 | West  | Furniture    | 120  
6 | West  | Office Supplies | 180  
7 | West  | Technology   | 220  

Arrows: WINDOW_SUM uses SUM([Sales]) from column C
Partitions can be by column A (Region) or columns A+B (Region+Category)
Cells referenced are the Sales values in column C, grouped by Region and Category in columns A and B
Result
    A       B               C       D
1 |Region | Category      | Sales | Window Sum
2 | East  | Furniture    | 100   | 450
3 | East  | Office Supplies | 150   | 450
4 | East  | Technology   | 200   | 450
5 | West  | Furniture    | 120   | 520
6 | West  | Office Supplies | 180   | 520
7 | West  | Technology   | 220   | 520
Column D shows WINDOW_SUM(SUM([Sales])) partitioned by Region, summing sales within each Region group
Sheet Trace Quiz - 3 Questions
Test your understanding
What does WINDOW_SUM(SUM([Sales])) calculate when no partition is set?
ASum of all sales in the entire table
BSum of sales per Region
CSum of sales per Category
DSum of sales per row
Key Result
WINDOW_SUM aggregates SUM([Measure]) over a defined partition or entire table

Practice

(1/5)
1. What does the Custom Table Calculation Scope control in Tableau?
easy
A. Which data points are included in the calculation
B. The color scheme of the visualization
C. The font size of labels
D. The data source connection type

Solution

  1. Step 1: Understand the purpose of table calculation scope

    The scope defines which data points Tableau uses when performing calculations like running totals or rankings.

  2. Step 2: Identify what is controlled by scope

    It controls the subset of data included in the calculation, not visual formatting or data source settings.

  3. Final Answer:

    Which data points are included in the calculation -> Option A

  4. Quick Check:

    Scope controls data points included [OK]
Hint: Scope means which data points calculation uses [OK]
Common Mistakes:
  • Confusing scope with visual formatting
  • Thinking scope changes data source
  • Mixing scope with filter settings
2. Which option correctly sets the scope of a table calculation to compute using only the Region dimension in Tableau?
easy
A. Compute Using > Pane (Across)
B. Compute Using > Table (Down)
C. Compute Using > Region
D. Compute Using > Table (Across)

Solution

  1. Step 1: Identify the dimension to set scope

    To limit calculation to the Region dimension, select Compute Using > Region.

  2. Step 2: Understand Compute Using options

    Options like Table (Down) or Table (Across) use the entire table direction, not a specific dimension.

  3. Final Answer:

    Compute Using > Region -> Option C

  4. Quick Check:

    Compute Using dimension name sets scope [OK]
Hint: Choose dimension name under Compute Using for scope [OK]
Common Mistakes:
  • Selecting Table (Down) instead of dimension
  • Confusing Pane with Table scope
  • Not selecting specific dimension
3. Given a sales table with dimensions Region and Category, what will be the result of a running total table calculation with scope set to Compute Using: Category for Region 'West'?
medium
A. Running total sums all data ignoring Region and Category
B. Running total resets for each Category within the West region
C. Running total resets for each Region ignoring Category
D. Running total sums all Categories across all Regions

Solution

  1. Step 1: Understand scope set to Category

    Compute Using Category means the running total computes along the Category dimension, restarting (partitioned) by other dimensions like Region.

  2. Step 2: Consider Region filter 'West'

    Filtered to West, the running total resets for each Category within the West region.

  3. Final Answer:

    Running total resets for each Category within the West region -> Option B

  4. Quick Check:

    Compute Using Category: along Category, reset by Region [OK]
Hint: Compute Using sets addressing (along), partition sets reset [OK]
Common Mistakes:
  • Thinking running total sums all regions
  • Ignoring filter on Region
  • Confusing scope with partitioning
4. You set a table calculation to Compute Using: Table (Across) but the running total is incorrect. What is the most likely cause?
medium
A. The table calculation is not enabled
B. The calculation is missing a filter
C. The data source is not connected
D. The data is arranged vertically, but scope is set horizontally

Solution

  1. Step 1: Analyze Compute Using Table (Across)

    This scope computes calculation across columns (horizontally).

  2. Step 2: Check data arrangement

    If data is arranged vertically (down rows), computing across columns causes incorrect results.

  3. Final Answer:

    The data is arranged vertically, but scope is set horizontally -> Option D

  4. Quick Check:

    Scope direction must match data layout [OK]
Hint: Match Compute Using direction to data layout [OK]
Common Mistakes:
  • Ignoring data layout when setting scope
  • Assuming filters cause running total errors
  • Thinking data source connection affects calculation
5. You want to create a running total of sales that restarts for each Region and sums across Category. Which custom table calculation scope should you use?
hard
A. Compute Using: Category, Restarting every Region
B. Compute Using: Region, Restarting every Category
C. Compute Using: Table (Down)
D. Compute Using: Pane (Across)

Solution

  1. Step 1: Understand requirement

    Running total should sum across Category but restart for each Region.

  2. Step 2: Set scope to Category and partition by Region

    Setting Compute Using to Category calculates running total across categories. Restarting every Region means partitioning by Region.

  3. Step 3: Confirm other options

    Other options do not correctly partition or compute as required.

  4. Final Answer:

    Compute Using: Category, Restarting every Region -> Option A

  5. Quick Check:

    Scope by Category with restart per Region [OK]
Hint: Compute Using dimension to sum, partition to restart [OK]
Common Mistakes:
  • Confusing which dimension to compute using
  • Not setting restart partition correctly
  • Using Table (Down) which sums entire table