Top and bottom report
The top / bottom report: a list of the best and worst items by sales, margin or sell-through speed. It helps decide quickly what to replenish and top up and what to mark down, move or delist.
Formula
Rows: top N and bottom N by a metric | Columns: metric, cumulative share, stock, cover, price, status, action
How to read
Suppose the top 10 of 400 items give 38% of revenue: check whether leaders have stock in all sizes, and for laggards find the cause: price, display, size, quality. Do not build the report without equal time on the shelf or without excluding sold-out items.