Loading data…
i Hover the i for what a number is and where it comes from. Red is under plan or down; green is over plan or up.
ASP vs plan, by product line
Over/Under % and Over/Under $ can point different ways: the % is a plain average over rep, item and month rows, while the $ adds up each row's gap times units sold, so big-volume months weigh more. Both colors follow the %, as in Power BI.
ASP trend by rep and month
Gross margin % by customer and month
Gross profit by customer, biggest first
Profit month
Year over year, same closed months
Detail by metric, subcategory and item
Year
Cost-based rows only cover items that have a unit cost on file. A cell adds up the items that sell at $1 or more a unit in that month; items under $1 (samples, bulk trim) drop out one by one.