At a glance
Top 10 Customers by 90-day revenue. Concentration check. The classic Pareto lens for Sales conversation.
| What it counts | SUM(Sales Invoice Header.Amount) grouped by Customer No. in 90D window, ranked descending, top 10. |
| Tax treatment | Net of VAT. |
| Currency | Reporting Currency. |
| Time window | 90D |
| Alert trigger | - |
| Roles | owner, finance |
Calculation
Calculated automatically from your Microsoft Dynamics 365 data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
US distributor on BC, 90D window 14 Jan to 13 Apr 26.| Rank | Customer | 90D Revenue (USD) | % of total |
|---|---|---|---|
| 1 | Acme Tech Distribution | $4,820,000 | 22% |
| 2 | NorthEast Components Inc | $2,140,000 | 10% |
| 3 | TechHub Wholesale | $1,820,000 | 8% |
| 4-10 | (other top customers) | $4,640,000 | 21% |
| Top 10 total | $13,420,000 | 61% |
Sibling cards merchants should reference together
| Card | Why pair |
|---|---|
| Top B2B Accounts | B2B-only ranked list. |
| Active Customers | Total count denominator. |
| Customer Credit Utilisation | Credit risk on top customers. |
| Customer Churn Signals | Early warning if a top customer slows. |
Reconciling against the vendor’s own dashboard
Where to look in Business Central:Reports > Sales > Top 10 Customer List Power BI > Sales Insights > Top Customers tileWhy may differ:
| Reason | Direction | Why |
|---|---|---|
| OData freshness | Card 15 min behind | |
| Multi-Company aggregation | Card sums |