GMAT Focus Edition — Data Insights: Table Analysis · Graphics Interpretation · Multi-Source Reasoning · Two-Part Analysis
Home Course Data Insights Lesson 11
Data Insights Lesson 11 of 20

Advanced
Table Mastery

AND filtering reduces rows; OR expands them. Derived metrics require mental math. Rankings differ by metric. Boundary values flip answers.

50 mins
🎯 DI 75 to 88
📚 Prereq: Lesson 1 (Table Analysis)
1

Multi-Column Sort Logic

Advanced TA questions require filtering on one column and evaluating another — or ranking on a derived value not shown in the table. The strategy: sort once, then scan for the relevant subset.

Sample Table: 8 Retailers
RetailerRevenue ($M)Stores (#)Online %EBITDA ($M)
Alpha$82021038%$92
Beta$4409561%$55
Gamma$1,10034022%$88
Delta$2706075%-$12
Epsilon$59014545%$71
2

Advanced Filtering Patterns

AND vs. OR Filtering
AND:
Both conditions must hold. Sort by condition 1, reduce to qualifying rows, then check condition 2 for those rows only.
OR:
Either condition may hold. Qualifying rows = those meeting condition 1 PLUS those meeting condition 2 (minus double-counted).
NOT:
Reverse the condition. Sort by the column, and count rows that do NOT meet the stated threshold.
3

Computing Derived Column Values

Common Derived Metrics in TA
Revenue per Store = Revenue / Number of Stores
EBITDA Margin = EBITDA / Revenue × 100%
Online Revenue = Revenue × Online %
Offline Revenue = Revenue × (1 − Online %)

Pro Tip: For derived metrics, mentally compute quick estimates. Alpha: $820M / 210 stores ≈ $3.9M/store. Gamma: $1,100M / 340 ≈ $3.2M/store. Alpha has higher revenue per store despite lower total revenue.

4

Ranking Assertions

Ranking Trap: Different Metrics

A company ranked #1 in total revenue may be ranked #3 in revenue per store and #5 in EBITDA margin. Ranking depends entirely on which metric is used. GMAT often contrasts rankings on different columns to test this.

5

10 Advanced TA Traps

⚠ Rank on total ≠ rank on ratio

The company with highest revenue may have the lowest revenue per employee if it also has the most employees.

⚠ AND filter: don't stop at first condition

When both conditions must hold, verify EVERY qualifying row meets both — not just the first one you check.

⚠ Derived metrics need mental math

Don't try to compute exact derived values. Estimate and compare. Precision beyond ±5% is rarely needed.

⚠ EBITDA margin vs. EBITDA

A company with EBITDA $92M on $820M revenue = 11.2%. One with $71M on $590M = 12.0%. Lower EBITDA, higher margin.

⚠ Missing data in a row

If one cell is blank or N/A, that retailer cannot satisfy conditions involving that column. Don't assume a value.

⚠ Sorting negative values

When sorting EBITDA ascending, negative values appear at the top. Don't misread a negative as a small positive.

⚠ "At most" vs. "fewer than"

At most 3 means ≤3. Fewer than 3 means <3 (i.e., at most 2). One threshold difference can flip the answer.

⚠ Computing online vs. offline revenue

Online revenue = Revenue × Online%. Don't confuse online % of revenue with online % of customers.

⚠ Multiple conditions can reduce to 0 rows

An AND condition with two restrictive filters might yield zero qualifying rows — making an "all of these" statement trivially True (vacuously true) or False depending on context.

⚠ Count precision near the boundary

If the question asks "more than 3" and you count exactly 3, the answer is False. Boundary values are frequent traps.

10 Practice Questions

Q1 of 10
TA~700

Using the retailer table (Alpha: Rev $820M, 210 stores, Online 38%, EBITDA $92M). Which retailer has the highest revenue per store?

Explanation: Beta — $4.6M per store. Revenue per store: Alpha 3.9, Beta 4.6, Gamma 3.2, Delta 4.5, Epsilon 4.1. Beta has the highest revenue per store despite not having the highest total revenue.
Q2 of 10
TA~650

Using the same table. Statement: All retailers with online share above 50% have negative EBITDA.

Explanation: False. Retailers with online > 50%: Beta (61%, EBITDA $55M positive) and Delta (75%, EBITDA -$12M negative). Beta has positive EBITDA, which violates "all have negative EBITDA." The statement is False.
Q3 of 10
TA~700

Which retailer has the highest EBITDA margin (EBITDA/Revenue)?

Explanation: Beta — ~12.5% EBITDA margin. Margins: Alpha 11.2%, Beta 12.5%, Gamma 8.0%, Epsilon 12.0%, Delta negative. Beta has the highest positive EBITDA margin.
Q4 of 10
TA~700

How many retailers have BOTH revenue above $400M AND more than 100 stores?

Explanation: 3 retailers. Filter Revenue > $400M: Alpha (820 ✓), Beta (440 ✓), Gamma (1100 ✓), Epsilon (590 ✓), Delta (270 ✗). From those 4: check stores > 100: Alpha (210 ✓), Beta (95 ✗), Gamma (340 ✓), Epsilon (145 ✓). Count = 3 (Alpha, Gamma, Epsilon).
Q5 of 10
TA~600

Statement: The retailer ranked first in total revenue is also ranked first in EBITDA.

Explanation: True. Highest revenue: Gamma ($1,100M). Highest EBITDA: Alpha ($92M). These are different companies. So the statement is False.
Q6 of 10
TA~700

Which retailer has the highest online revenue (Revenue × Online%)?

Explanation: Alpha — $311.6M online revenue. Despite Alpha's lower online percentage (38%), its large total revenue ($820M) gives it the highest absolute online revenue.
Q7 of 10
TA~700

A TA question asks "How many companies have revenue per store greater than $4M?" Based on the table, the answer is:

Explanation: 2 companies. Revenue/store: Alpha 3.9, Beta 4.6, Gamma 3.2, Delta 4.5, Epsilon 4.1. Those above $4M: Beta (4.6) and Delta (4.5). Count = 2.
Q8 of 10
TA~550

Statement: Gamma has both the highest revenue and the most stores among the five retailers.

Explanation: True. Gamma has the highest revenue ($1,100M) and the most stores (340). Both conditions are satisfied simultaneously. True.
Q9 of 10
TA~600

If you need to find "which retailer has the highest EBITDA margin," but EBITDA margin is not a column in the table, you should:

Explanation: Compute EBITDA/Revenue mentally for each row. When the required metric is not a column, you must compute it from available columns. Quick mental division or estimation for each candidate row is the correct approach.
Q10 of 10
TA~600

Statement: Exactly two retailers have a negative or zero EBITDA.

Explanation: False. Only Delta has negative EBITDA (−$12M). All others (Alpha $92M, Beta $55M, Gamma $88M, Epsilon $71M) are positive. Exactly ONE retailer has negative/zero EBITDA, not two.
Lesson Summary
AND filter: apply the more restrictive condition first

This reduces the candidate rows, making the second check faster.

Derived metrics: estimate, don't compute exactly

Quick mental division to ±5% accuracy is sufficient for ranking questions.

Rankings differ by metric — always check which metric

The top revenue company may rank 3rd in profit margin. They are different questions.

Negative values sort to the top (ascending)

Sorting EBITDA ascending brings losses to the top. Don't misread as small positives.