AnalystReps

Tableau practice: Secondary table calculations and ratios

Chapter 16 · 5 questions · included in full access

  1. Question 1 · medium

    Percent of total

    Create % of Total: each mark's SUM(Sales) divided by the total of all marks in the view: SUM([Sales]) / TOTAL(SUM([Sales])).

    Solve it in your browser

  2. Question 2 · easy

    TOTAL versus WINDOW_SUM

    How does TOTAL(AVG([Sales])) differ fundamentally from WINDOW_AVG(AVG([Sales]))?

    Solve it in your browser

  3. Question 3 · hard

    Gap to average rep

    Create Gap to Average: how far each rep's total Sales is above or below the average rep: SUM([Sales]) - WINDOW_AVG(SUM([Sales])).

    Solve it in your browser

  4. Question 4 · medium

    Unit volume share of total

    Create Units % of Total: each mark unit volume divided by total volume across all marks: SUM([Units]) / TOTAL(SUM([Units])).

    Solve it in your browser

  5. Question 5 · medium

    Category revenue share matrix

    Build a view displaying Category on Rows and SUM(Sales) on Columns.

    Solve it in your browser

These questions are part of full access.

The first chapters of every track are free. Full access is a one-time payment.

See pricing