Objective and professional context
Two fictional reporting rows contain 10000 and 90000 revenue cents, with 6000 and 81000 cost cents. The first row has a larger margin percentage but a much smaller revenue weight. A dashboard should keep the measure definition, units and population visible. In Tableau, a row-level gross-profit field can be aggregated, while the overall margin is the sum of gross profit divided by the sum of revenue.
Your practical assignment
Calculate the weighted gross margin and compare it with the equal average of the two row margins. Write the exact Tableau calculated field and an empty-selection policy.
Worked solution and interpretation
Gross profit is 13000 cents on 100000 revenue cents, so margin is 13%. The equal average of 40% and 10% is 25%, which is a different weighting. Return unavailable for a zero revenue denominator.
Verification, mistakes and limits
For a native Tableau check, connect only this fictional CSV, inspect numeric types, define Gross Profit=[revenue_cents]-[cost_cents], then IF SUM([revenue_cents])=0 THEN NULL ELSE SUM([Gross Profit])/SUM([revenue_cents]) END. Export the underlying table to reconcile. The provided reference verifies arithmetic, not a pretested .twb file.
Continue with evidence
Keep the unchanged data, your implementation and a changed-input result with a short note explaining what you can and cannot conclude. These free companions do not change saved course progress. The published course catalogue shows deeper assignments available under your current permissions. Keep your conclusions proportional to the evidence you have inspected.
Authoritative reference
Official technical method reference; it does not validate fictional outcomes or your own software environment.
Try the activity before reading its reference. Keep your sources, commands and assumptions with your work. Companion activities are unsaved self-practice and do not award a certificate or change lesson progress.