Retail revenue
& returns.
A closer look at where recorded sales activity sits, how it moves, and what the transaction data can actually support.
THE OPERATING QUESTION
Where is positive sales activity concentrated, and what do cancellations and negative-quantity lines reveal?
The sales picture
Activity over time
Monthly aggregation across the selected period
Where the value sits
Full source period · eligible positive lines
Sales by country
Top countries by positive line value
Highest-value codes
Source descriptions are shown as supplied
| STOCK CODE / DESCRIPTION | UNITS | LINE VALUE | SHARE |
|---|---|---|---|
| Loading stock-code totals... | |||
Waiting for verified country totals.
Waiting for verified stock-code totals.
Waiting for the monthly series.
What the IDs reveal
Identified-customer cohort only
Customer continuity
Distinct eligible invoices per identified customer
Customer measures exclude rows without CustomerID. They describe only the identified-customer cohort and should not be generalized to all source transactions.
Two different signals
Never combine these into one return metric
Know the weak points
Source workbook · measured at build time
The data audit has not loaded yet.
What the numbers mean
Definitions are part of the analysis
Gross positive line value
Quantity × UnitPrice for rows with a non-cancellation invoice identifier, a valid invoice date, Quantity above zero and UnitPrice above zero. All stock codes are retained.
Not net revenue or profit
The dashboard does not subtract cancellation or negative-quantity activity from positive line value. The source has no cost-of-goods-sold field, so profit and margin cannot be calculated.