Skip to content
Tableau
All coursesPlacement Report
‹ Back to previous sectionCourse homeAll page URLs

Table Calculations Interview Questions for Tableau

23 Table Calculations questions with answers for tableau roles — 6 easy, 13 medium, 4 hard.

About Table Calculations

Table calculations work on aggregated results in the view. Master running totals, period-over-period growth, moving averages, ranks, percent of total and Pareto analysis, along with addressing, partitioning and Compute Using settings. You will also learn table calculation filters and when to choose an LOD expression instead of a table calculation.

Sheet progressStart practicing
3 QUESTIONS FREESign up to unlock the full question bank and track your progress.Unlock every question and answer, then continue practising company-wise and package-wise.
3 questions free Unlock the rest in seconds
01

What is a table calculation in Tableau?

Table CalculationsEasy
Save to ▾
Show answer
A table calculation is computed on the aggregated values already in the view, rather than in the data source. Examples include running total, difference, percent difference, percent of total, rank, percentile and moving average. Because they work on the result table, their output depends on the dimensions in the view and on the direction set by Compute Using. A delta symbol appears on the pill.
02

What are quick table calculations?

Table CalculationsEasy
Save to ▾
Show answer
Quick table calculations are ready-made table calcs available from a measure pill's dropdown: running total, difference, percent difference, percent of total, rank, percentile, moving average, YTD total, compound growth rate, year over year growth and YTD growth. They are fast to apply and can be edited later to change addressing or turned into a calculated field by dragging the pill to the Data pane.
03

Create a running total of sales by month.

Table CalculationsEasy
Save to ▾
Show answer
Place MONTH(Order Date) continuous on Columns and SUM(Sales) on Rows. Use quick table calc Running Total, or write: RUNNING_SUM(SUM([Sales])) Set Compute Using to Order Date. To restart each year, add YEAR(Order Date) to the view and compute along month only, making year the partition.
04

How do you handle pressure when a dashboard is needed urgently?

Table CalculationsEasy
Save to ▾
Show answer
Situation: a director needed weekly sales numbers for a board call in three hours. Task: deliver correct numbers fast. Action: I clarified the exact metrics, reused an existing certified data source, built a simple view first, validated totals with finance, then improved formatting. Result: the numbers were ready in two hours and matched finance, and I later added the view to our standard dashboard.
05

What do INDEX, FIRST, LAST and SIZE return?

Table CalculationsEasy
Save to ▾
Show answer
INDEX returns the position of the current row in the partition starting from 1. FIRST returns the offset from the current row to the first row, so it is 0 on the first row and negative afterwards. LAST returns the offset to the last row, 0 on the last row. SIZE returns the number of rows in the partition. They are used for filtering, labelling and custom calculations.
06

A manager wants the grand total row to show the sum of displayed values, but it shows something else. Why?

Table CalculationsEasy
Save to ▾
Show answer
Grand totals in Tableau are computed at a higher level using the same aggregation, so for averages or ratios the total is recomputed rather than summed. For table calculations or LODs, results can look inconsistent. Right-click the measure, choose Total Using and select Sum to add displayed values, or create a custom calculation using WINDOW_SUM. Confirm with the manager which total makes sense.
07

What do addressing and partitioning mean in table calculations?

Table CalculationsMedium
Save to ▾
Show answer
Addressing fields define the direction the calculation moves along, such as across months. Partitioning fields define the groups where the calculation restarts, such as each region. In Compute Using, checked dimensions are addressing and unchecked ones are partitioning. For a running total of sales by month restarting each year, month is addressing and year is partitioning.
08

What are the Compute Using options such as Table Across and Pane Down?

Table CalculationsMedium
Save to ▾
Show answer
Table Across computes left to right across the whole table, Table Down top to bottom, Table Across then Down moves across then wraps, Pane options restrict the calculation to each pane, Cell computes within a single cell, and Specific Dimensions lets you tick exact addressing fields. Specific Dimensions is the most reliable because it does not change when the layout is rearranged.
09

What are the main table calculation functions?

Table CalculationsMedium
Save to ▾
Show answer
Key functions are RUNNING_SUM, RUNNING_AVG, WINDOW_SUM, WINDOW_AVG, WINDOW_MAX, LOOKUP, PREVIOUS_VALUE, INDEX, FIRST, LAST, SIZE, RANK, RANK_DENSE, RANK_PERCENTILE and TOTAL. They operate on aggregates, so arguments must be aggregated, such as RUNNING_SUM(SUM([Sales])). WINDOW functions accept start and end offsets for moving calculations.
10

What is the difference between RANK, RANK_DENSE, RANK_MODIFIED and RANK_UNIQUE?

Table CalculationsMedium
Save to ▾
Show answer
For values 100, 90, 90, 80: RANK gives 1, 2, 2, 4 (competition ranking). RANK_DENSE gives 1, 2, 2, 3 without gaps. RANK_MODIFIED gives 1, 3, 3, 4. RANK_UNIQUE gives 1, 2, 3, 4, breaking ties by order. Choose based on business rules, for example dense ranking for leaderboards where ties should share a position without skipping.
11

What does LOOKUP do and how is it used?

Table CalculationsMedium
Save to ▾
Show answer
LOOKUP(expression, offset) returns the value of an aggregate from another row in the partition, relative to the current row. LOOKUP(SUM([Sales]), -1) returns the previous period, useful for period-over-period difference. Positive offsets look forward. FIRST() and LAST() can be used as offsets to compare every row with the first or last period.
12

Calculate month-over-month percentage growth.

Table CalculationsMedium
Save to ▾
Show answer
MoM Growth: (SUM([Sales]) - LOOKUP(SUM([Sales]), -1)) / ABS(LOOKUP(SUM([Sales]), -1)) Compute along month. The first month returns null because there is no previous value. Format as percentage and colour positive and negative values differently for quick reading.
13

Create a 3-month moving average of sales.

Table CalculationsMedium
Save to ▾
Show answer
Moving Avg: WINDOW_AVG(SUM([Sales]), -2, 0) This averages the current month and the two previous months. Compute along month. Use a dual axis to show actual sales as bars and the moving average as a line, which smooths seasonal noise for trend analysis.
14

Show each product's rank within its category.

Table CalculationsMedium
Save to ▾
Show answer
Rank: RANK(SUM([Sales]), 'desc') Place Category and Product on Rows. In Edit Table Calculation choose Specific Dimensions, tick Product only so the rank restarts for each category. Add a filter on the rank calculation, set to at most 5, to show the top five products in every category.
15

Build a Pareto chart showing what share of customers drive 80 percent of sales.

Table CalculationsMedium
Save to ▾
Show answer
Sort customers by sales descending on Columns. Running share of sales: RUNNING_SUM(SUM([Sales])) / TOTAL(SUM([Sales])) Running share of customers: INDEX() / SIZE() Use a dual axis with bars for sales and a line for running percent, and add a reference line at 0.8.
16

After rearranging the view, your percent of total gives wrong numbers. Why?

Table CalculationsMedium
Save to ▾
Show answer
The table calc was probably set to Table Across or Table Down, which depends on layout. When fields move between Rows and Columns, the direction changes. Edit the table calculation and set Compute Using to Specific Dimensions with the correct addressing fields. Then the calculation stays correct even if users or developers reorganise the sheet.
17

A rank changes when the user selects a filter value. The business wants overall rank. What do you do?

Table CalculationsMedium
Save to ▾
Show answer
Normal filters remove rows before the rank is computed, so rank recalculates on the filtered set. Either replace the filter with a table calculation filter such as LOOKUP(MIN([Product]), 0), which hides rows after ranking, or compute rank with an LOD-based approach. Explain both behaviours to the user and confirm which rank they actually need.
18

Sales team wants year over year growth for each month on a single chart. How do you build it?

Table CalculationsMedium
Save to ▾
Show answer
Place MONTH(Order Date) discrete on Columns and YEAR(Order Date) on Color with SUM(Sales) on Rows. Add a quick table calculation Percent Difference, compute using Year, relative to previous. Each month now shows growth versus the same month last year. Alternatively calculate with LOOKUP(SUM([Sales]), -1) partitioned by month and addressed by year.
19

Tell me about a mistake you made in a report and how you handled it.

Table CalculationsMedium
Save to ▾
Show answer
Situation: I published a dashboard where a percent of total used Table Across and gave wrong numbers after a layout change. Task: fix it and rebuild trust. Action: I informed the stakeholder immediately, corrected the calc with Specific Dimensions, added a validation sheet comparing totals, and re-shared. Result: the issue was fixed within an hour, and I now test calcs after every layout change.
20

Why does filtering on a table calculation behave differently from a normal filter?

Table CalculationsHard
Save to ▾
Show answer
Table calculation filters apply at the end of the order of operations, after the calculation, so they hide marks without removing data from the computation. A normal dimension filter removes rows before the calc, changing running totals and ranks. To show only the last three months while keeping a running total from the start, filter with a table calc such as LAST() <= 2.
21

When would you choose an LOD over a table calculation?

Table CalculationsHard
Save to ▾
Show answer
Choose an LOD when the result must be used as a dimension, a filter, in another data source level calculation, or must stay correct regardless of view layout, such as a customer's first purchase. Choose a table calculation for sequence-based logic such as running totals, ranks, moving averages and previous period values. LODs run in the database; table calcs run locally on the result set.
22

Show only the latest 6 months while running totals start from the first month.

Table CalculationsHard
Save to ▾
Show answer
Keep all months in the view. Create: Last N Filter: LAST() < 6 Compute along month and put it on Filters set to True. Because table calc filters apply after the running sum, earlier months are hidden but still counted. A normal date filter would reset the running total.
23

A workbook with many nested table calculations is slow in the browser. How do you approach it?

Table CalculationsHard
Save to ▾
Show answer
Table calcs run on the result set, so large numbers of marks make them slow. Reduce marks by aggregating to the needed level, filter data earlier with context or data source filters, replace some table calcs with LODs or database-side calculations, and avoid nested WINDOW functions over thousands of rows. Use a performance recording to confirm computing layouts and query time.

Frequently asked questions

How important is Table Calculations in Tableau interviews?

Table calculations work on aggregated results in the view. Master running totals, period-over-period growth, moving averages, ranks, percent of total and Pareto analysis, along with addressing, partitioning and Compute Using settings. You will also learn table calculation filters and when to choose an LOD expression instead of a table calculation.

How should I use the Table Calculations sheet?

Go top to bottom — easy to hard. Answer before opening each answer, tick what you solved and save misses to Last-Minute Revision.

More question sheets

Tableau Fundamentals questionsData Connections and Modelling questionsCalculated Fields questionsLOD Expressions questionsCharts and Visual Design questionsFilters, Parameters and Actions questionsDashboards and Tableau Server questions