- Sales $
- Hoodie retail sell-through dollars at the dispensary register. It is not Claybourne QuickBooks net sales.
- Units
- Hoodie retail units sold.
- Weighted Avg Price
- Sales $ divided by Units for the same brand, month and filters. Blank when units are 0.
- Door Count
- Stores that sold the brand in the month, as Hoodie counts them. Blank when several categories or package sizes are selected (see Several values selected).
- Distribution Points (Approx.)
- Store by product listings that sold, as Hoodie counts them. Approximate.
- Avg SKUs/Door (Approx.)
- Distribution points divided by door count. Approximate. Blank when Door Count is blank.
- Rank
- Hoodie's stored rank of the brand for that month and slice. The page never re-ranks it. Blank when the selection adds several slices together (see Several values selected).
- Filters
- Category, Package size, Banner and Store are dropdowns: select one value or several. State takes one value. Hoodie's data has no category or size split by banner or store, so selecting a banner locks category and size, and the reverse.
- Several values selected
- A selection of stores counts only those stores. When the selection covers several slices, Sales $, Units and Distribution Points are added across them, and Weighted Avg Price is the added sales divided by the added units. Door Count is added across banners and stores, and Avg SKUs/Door is the added points divided by the added doors. Both are blank across several categories or sizes, because a store that sells both would count twice. Rank is blank: Hoodie ranks one slice at a time. A cell is also blank when Hoodie's data has no total row for one of the selected banners in that month: a sum without it would be too low. With one value per filter every metric shows.
- Brand
- Select one or more brands in the dropdown to show only those rows. Nothing selected shows all brands. The selection only hides rows: values, ranks and the Claybourne tiles do not change.
- Months
- The last 13 months in Hoodie's data, ending at the latest month loaded. The first column's colour compares with the month before it. The table opens sorted on the latest month, highest first.
Power BI's Volume Driver still shows the October 13 cut, through September. Hoodie has restated earlier months since, so past months here differ from Power BI (September Claybourne CA sales: $4,055,011.10 there, $4,044,233.82 here).
Blank by design: Rank is blank when the selection adds several slices together (several categories, sizes, banners or stores), because Hoodie ranks one slice at a time and the page never re-ranks. Door Count and Avg SKUs/Door are blank when more than one category or package size is selected, because a store that sells both would count twice. With several banners, a cell is blank when Hoodie's data has no total row for one of them in that month, because a sum without it would be too low. Select one value per filter to see every metric.
Distribution Points and Avg SKUs per Door are approximate in Hoodie's data. They keep the Approx. label.