Blog · Board and management reporting
An interactive dashboard lets business readers compare the same measures across selected segments. Follow a worked sales export through consistent filters, correctly weighted margins, and checks that make every selected view explainable.
An interactive dashboard lets a reader filter business measures by period, region, customer, or product and compare the selected results. The useful part is a reliable answer to a business question. Every selected view needs an explicit scope and a denominator that matches the question.
Write down what each selection changes. A region filter might change revenue, cost, gross profit, and margin together. A company comparison might stay fixed. Both approaches can work, but a reader must be able to tell which one is in use.
Use labels such as “Selected region revenue” and “Share of company revenue.” The first describes the selected rows. The second divides selected revenue by an intentionally unfiltered company total. An unexplained label such as “Revenue share” leaves the denominator ambiguous.
Also choose a default period and source cutoff. A reader returning to the full view should recover a known baseline. Keep a visible summary of selections, especially when customer and product filters overlap. A blank region means missing classification, not permission to discard its sales.
For spreadsheet construction steps, use the Excel dashboard guide. The method here establishes the business rules that should hold regardless of how the final view is built.
A US distributor wants to compare September 2026 gross margin by region and product. Its summarized export contains these rows, after discounts and credits. Cost covers the same sales and uses the same accounting definition throughout.
Place region in column A, product in B, revenue in C, and cost of goods sold in D. The header is row 1 and the records occupy rows 2 through 5.
| Region | Product | Revenue (USD) | COGS (USD) | Gross profit (USD) | Gross margin |
|---|---|---|---|---|---|
| East | A | 120,000 | 78,000 | 42,000 | 35.00% |
| East | B | 80,000 | 56,000 | 24,000 | 30.00% |
| West | A | 150,000 | 97,500 | 52,500 | 35.00% |
| West | B | 50,000 | 30,000 | 20,000 | 40.00% |
| Company | 400,000 | 261,500 | 138,500 | 34.63% |
The company check is revenue less cost: 400,000 − 261,500 = 138,500. Divide gross profit by revenue to obtain 34.625%, displayed as 34.63%. Round only the displayed percentage; retain the underlying precision for comparisons.
The gross profit margin method explains the accounting measure in detail. Here the important rule is that every selection recomputes it from amounts.
The following Google Sheets formulas illustrate the calculation behind the selected result. Put the selected region, initially East, in H2 and selected product, initially A, in H3. These are criteria cells; the dashboard interface may present the same choices differently.
Google's SUMIFS documentation specifies summing a range subject to multiple criteria. Selected revenue in H5 is:
=SUMIFS($C$2:$C$5,$A$2:$A$5,$H$2,$B$2:$B$5,$H$3)
Selected cost in H6 uses exactly the same criteria:
=SUMIFS($D$2:$D$5,$A$2:$A$5,$H$2,$B$2:$B$5,$H$3)
Gross profit in H7 and margin in H8 are:
=H5-H6
=IFERROR(H7/H5,"No revenue")
IFERROR returns a specified alternative when a calculation errors. Investigate unexpected errors in the source before presenting the view; an error handler does not validate the data. A selection with no revenue should display “No revenue,” rather than a margin of zero.
To compare a region across all products, remove the product criterion from both amount formulas. Regional revenue becomes:
=SUMIFS($C$2:$C$5,$A$2:$A$5,$H$2)
Use column D instead of C for regional cost. Do not type All into H3 and expect the first formula to infer that meaning: without an explicit interface rule it searches for a product literally called All.
Covirage is not affiliated with Google or Microsoft.
These views all come from the same source rows:
| Selection | Revenue (USD) | Gross profit (USD) | Gross margin | Share of company revenue |
|---|---|---|---|---|
| East, product A | 120,000 | 42,000 | 35.00% | 30.00% |
| East, all products | 200,000 | 66,000 | 33.00% | 50.00% |
| West, all products | 200,000 | 72,500 | 36.25% | 50.00% |
| All regions, product A | 270,000 | 94,500 | 35.00% | 67.50% |
| Full company | 400,000 | 138,500 | 34.63% | 100.00% |
East product A's margin is 42,000 / 120,000 = 35.00%. Its company revenue share is 120,000 / 400,000 = 30.00%. If the question instead asks for its share of East revenue, the denominator becomes 200,000 and the answer changes. Keep that question in the label.
West has the same revenue as East but more gross profit. That supports an investigation of prices, costs, and product mix; it does not by itself prove better sales execution. Product A's margin is identical across regions, while product B's margins differ.
For layout choices after the definitions are stable, see Excel dashboard examples for finance and sales.
Start from the full company view. Select East and verify revenue of $200,000 and gross profit of $66,000. Then select product A as well and recover the first source row. Return to the full view and verify the original totals.
Use mutually exclusive segments for the reconciliation. East and West revenue sum to $400,000; their gross profit sums to $138,500. Do not add East revenue to product A revenue: those sets overlap. Include an empty selection test and a test of missing customer or region labels before sharing the dashboard.
When a view fails to reconcile, use a dashboard audit to compare its definitions and amounts with the source export.
Bring a sales export with customer, product, region, revenue, and matching cost columns. Covirage maps the columns, and its tools compute and check the figures; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See self-service analytics for the supporting approach to business files.
Readers can change the selection and inspect the resulting measures rather than viewing one fixed report. Useful interactions include selecting a region, narrowing a period, and opening supporting detail. Each change should preserve a clear definition of the rows included.
Measures describing the selected business should follow the same filter. A company benchmark may deliberately remain fixed, but its label must say so. Mixing a selected numerator with an unlabeled company denominator can make a valid calculation misleading.
The region may contain a different mix of products, prices, or costs. Recompute selected gross profit divided by selected revenue, then inspect the product rows. An average of displayed percentage margins can produce a different and incorrect regional result.
Start with the full source total, then select one segment and reconcile it to its rows. Test combined filters, an empty selection, and a return to the full view. For mutually exclusive segments, selected and excluded amounts should add back to the original total.