![mousemat.png]](https://fundamentals.theretailscore.com/hs-fs/hubfs/mousemat.png?height=40&name=mousemat.png){kind=small}
Definitions of Sales measures
List of definitions for Sales measures found in the Retail Sales Module of the Master Template cube
| FACT | FIELD NAME | DEFINITION |
| Sales | Docket Number | Unique chronological number generated by the system at the time a sale is processed. Each Transaction generates a unique Docket number which is documented on the Customer Receipt. The details of the sales transaction is stored against the docket number. |
| Sales | Transaction Number | The POS generated Transaction number unique to a location |
| Sales | Is Return | Flag to filter on Transactions that include a Return 'Y' or do not inlcude a Return 'N'. Rule: If Sales Units <0 then 'Y' else 'N' |
| Sales | Is Markdown Sale | Flag to filter on Transactions that include a Permanent Markdown 'Y' or do not include a Permanent Markdown 'N' |
| Sales | Is Temp Discount Sale | Flag to filter on Transactions that include a Temporary Discount 'Y' or do not include a Temporary Discount 'N' |
| Sales | Is True Discount Sale | Flag to filter on Transactions that include a Temporary and/or Permanent Discount 'Y' or do not include any Discount 'N' |
| Sales | Is Net Return | Flag to filter on Transactions that have a return where the net value of the transaction is negative 'Y' or 'N', This takes into account the net value of a return after exchanges within the one transaction. Rule: If total docket value < 0, then 'Y', else "N" |
| Sales | Is Named Sale | Flag to filter on transactions where the sale has been attributed to a member ID |
| Sales | Is New Member Sale | Flag to filter on Sale Transactions where the Sale has been attributed to a New Member ID. A new member is someone who has had a sale within 30 days of their joined date |
| Sales | Is First Member Sale | Flag to filter on Sale Transactions where the Sale has been attributed to a Member who is registering their first sales transaction. |
| Sales | Sales Units | Net Sales Quantity of all units sold, includes Returns, during a defined calendar period. |
| Sales | Sales $ | Net Sales $ value of Sales transactions during a defined calendar period, including Returns and with all Discounts applied |
| Sales | Sales $ Incl GST | Net Sales $ value (including GST) of Sales transactions during a defined calendar period, including Returns and with all Discounts applied |
| Sales | Sales Tax $ | The Tax component of the Net Sales $ value of Sales transactions during a defined calendar period, including Returns and with all Discounts applied |
| Sales | COGS $ | Cost of goods sold (COGS) is the weighted average standard cost value of goods sold during a defined calendar period. |
| Sales | GP $ | Gross Profit (GP) $ is the difference between the Sales $ and the COGS $. This can also be referred to as Gross Margin |
| Sales | GP % | Gross Profit shown as a % of Sale $ |
| Sales | GP $ (All Stores) | Gross Profit (GP) $ is the difference between the Sales $ and the COGS $. This can also be referred to as Gross Margin |
| Sales | GP % (All Stores) | Gross Profit shown as a % of Sale $ |
| Sales | GP % (All Products) | Gross Profit shown as a % of Sale $ |
| Sales | GP % Index to Total | Gross Profit $ as a % of Sale $ Indexed to the Grand Total GP % of all Products. This is a statistical way to compare the relative change of a product, or it's hierarchy, where the base (Grand Total GP %) is 100. |
| Sales | GP % Contribution | Gross Profit (GP) % as a Contribution of the Sales $ % Mix. This provides another perspective on the GP results where the Grand Total GP % Contribution = overall GP % and the product breakdown shows the contribution of GP % to the Sales $ Mix % |
| Sales | Sales Before Temp Discount $ | The Sales value of the transaction as if there was no temporary markdown taken. Sales $ + Temp Discount $ |
| Sales | Sales Before Temp Discount $ Incl GST | The Sales value of the transaction as if there was no temporary markdown taken. Sales $ + Temp Discount $ |
| Sales | Temp Discount $ | Temp Discount value at time of Sales. incl both POS and Promo discount |
| Sales | Temp Discount % | Temp Discount amount as a % of pre discount value at the time of sale |
| Sales | Temp Discount Tax $ | Sale GST Tax amount of Temp Discount value |
| Sales | Gross $ | Gross Sales $ are the Sales $ after Returns and before Total Discounts |
| Sales | Gross $ Incl GST | Gross Sales $ (includes GST) are the Sales $ after Returns (incl GST) and before Total Discounts (incl GST) |
| Sales | Perm Markdown $ Incl GST | Markdown value at time of Sales (incl GST) |
| Sales | Temp Discount $ Incl GST | Temp Discount value at time of Sales (incl GST) |
| Sales | Sales Units (All Products) | Net Sales Quantity of all units sold, including returns, during a defined calendar period for All Products regardless of Product filters applied to the pivot. |
| Sales | Sales Units Mix % | Sales Units as a % Mix of the Total Sales Units |
| Sales | Sales Units Mix % (All Stores) | Sales Units as a % Mix of the Total Sales Units for All Locations regardless of the location filters applied to the pivot. |
| Sales | Sales $ (Total) | Net Sales $ value of Sales transactions during a defined calendar period, including Returns and with all Discounts applied. Results are for total sales regardless of filters applied to the pivot. |
| Sales | Sales $ (All Salespeople) | Net Sales $ value of Sales transactions during a defined calendar period, including Returns and with all Discounts applied. Results are for total Salespeople regardless of Salespeople filters applied to the pivot. |
| Sales | Sales $ (All Stores) | Net Sales $ value of Sales transactions during a defined calendar period, including Returns and with all Discounts applied. Results are for All Locations regardless of Location filters applied to the pivot. |
| Sales | Sales $ (000s) | Net Sales $ value of Sales transactions during a defined calendar period, including Returns and with all Discounts applied. Sales $ of a Transaction represented in thousands ie $10 represents $10,000 |
| Sales | Sales $ (All Products) | Net Sales $ value of Sales transactions during a defined calendar period, including Returns and with all Discounts applied. Results are for All Products regardless of Product filters applied to the pivot. |
| Sales | Sales $ Mix % | Sales $ as a % of the Total Sales $ for the defined calendar period |
| Sales | Sales $ Mix % (All Stores) | Sales $ as a % of the Total Sales $ for the defined calendar period. Results are for All Locations regardless of Location filters applied to the pivot. |
| Sales | COGS $ (All Products) | Cost of goods sold (COGS) is the weighted average standard cost value of goods sold during a defined calendar period. Results are for All Products regardless of Product filters applied to the pivot. |
| Sales | COGS $ Mix % | COGS $ as a % Mix of the Total COGS $ for the defined calendar period. |
| Sales | Avg Cost Price | Average Cost Price is the weighted average standard cost of goods which have been sold in a defined calendar period. This is calculated by dividing the COGS by the quantity of units sold. |
| Sales | Returns Units | Return Units is the quantity of all units returned for either a refund or exchange, during a defined calendar period |
| Sales | Sales Units Excl Returns | Sum of all Units sold during a defined calendar period. These Sales have NOT been adjusted for Returns including Refunds and Exchanges. |
| Sales | Excl Returns Sales $ | Sales $ value of products sold during a defined calendar period, with all Discounts applied. They do NOT include any Returns (defined as both refunds and exchanges) transaction. |
| Sales | Excl Returns Sales $ Incl GST | Sales $ value + the GST of products sold during a defined calendar period, with all Discounts applied. They do NOT include any Returns (defined as both refunds and exchanges) transaction. |
| Sales | Excl Returns COGS $ | Cost of goods sold (COGS) excluding returns transactions is the weighted average standard cost value of goods sold, during a defined calendar period, excluding any transaction value of both returns and refunds. |
| Sales | Excl Returns Before Total Discount $ | Sales $ Before Total Discount $ excluding Returns Sales Transactions |
| Sales | Excl Returns GP $ | Gross Profit (GP) $ excluding returns is the difference between the Sales $ and the COGS $ excluding all refund and exchanges transaction values. This can also be referred to as Gross Margin excluding returns |
| Sales | Excl Returns # Sales Trnx | Number of Sales Transactions excluding all negative transactions over a defined calendar period. These transactions are NOT adjusted for returns (defined as both refunds and exchanges). # Sales Transactions - # Returns Transactions |
| Sales | Excl Returns % Sales Trnx | Number of Sales Transactions that exclude Returns Transactions as a % of the total number of all Sales Transactions over a defined calendar period |
| Sales | Excl Returns Temp Discount $ | The Temp Discount value of sales transactions at time of Sales over a defined calendar period excluding all return transactions |
| Sales | Excl Returns Temp Discount $ Incl GST | The Temp Discount value inclusive of GST of sales transactions at time of sale over a defined calendar period excluding all return transactions |
| Sales | Net Returns $ | Value of Net Returns at Sales $ where the net sales value of the docket number is negative after returns and exchanges. I.e. Sales $ where Is Net Return is 'Y' |
| Sales | Net Returns $ Incl GST | Value of Net Returns at Sales $ inclusive of GST over a defined calendar period, where the net sales value inclusive of GST of the docket number is negative (after returns and exchanges). I.e. Sales $ incl GST where Is Net Return is 'Y' |
| Sales | Net Returns $ % | Net Returns $ Value as a % of Sales $ over a defined calendar period |
| Sales | Net Returns COGS $ | Value of Net Returns at COGS $ over a defined calendar period, where the net sales value of the docket number is negative (after returns and exchanges). I.e. COGS $ where Is Net Return is 'Y' |
| Sales | Net Returns Total Discount $ | Sales $ Value of Total (aka True) Discount of the Net Returns $ i.e. True discount value where is net returns is 'Y' |
| Sales | Net Returns Before Total Discount $ | Sales $ Value of Net Returns $ before adjustments for any discounts are applied over a defined calendar period. |
| Sales | Net Returns GP $ | Value of Net Returns at GP $ over a defined calendar period, where the net sales value of the docket number is negative (after returns and exchanges). Ie GP $ where Is Net Return is 'Y' |
| Sales | Net Returns # Sales Trnx | Number of Sales Transactions of Net Returns over a defined calendar period. I.e. Distinct Count of sales transaction where Is Net Return = 'Y' |
| Sales | Net Returns % Sales Trnx | Number of Net Return Sales Transactions as a % of the total number of all Sales Transactions over a defined calendar period |
| Sales | Net Returns Units | Quantity of Net Returns Units (where the sales units of a transaction is negative after returns and exchanges) over a defined calendar period. Ie Sales Qty where Is Net Return = 'Y' |
| Sales | Returns $ | Value of Returns at Sales $ over a defined calendar period, where the sales transactions includes any negatives. I.e. Sales $ where Is Return is 'Y' |
| Sales | Returns $ Incl GST | Value of Returns at Sales $ incl GST over a defined calendar period, where the sales transactions includes any negatives (both returns and exchanges). I.e. Sales $ incl GST where Is Return is 'Y' |
| Sales | Returns $ % | Returns $ as a % of the total Sales $ excluding Returns |
| Sales | Returns COGS $ | Total COGS $ value of the Returns Transaction |
| Sales | Returns Temp Discount $ | Temp Discount value of Returns Sales Transaction |
| Sales | Returns Temp Discount $ incl GST | Temp Discount value of Returns Sales Transaction (incl GST) |
| Sales | Returns Before Total Discount $ | Returns $ before Total Discounts $ are applied (Gross Return $) |
| Sales | Returns GP $ | Total GP $ value of the Returns Sales |
| Sales | Returns # Sales Trnx | Distinct count # Return Sales Transactions where 'Is Return' flag = "Y" |
| Sales | Returns % Sales Trnx | # Return Sales Transactions as a % to the total number of Sales Transactions |
| Sales | Markdown % | Perm markdown Sales $ as a % of Sales $ before Perm markdown amount deducted |
| Sales | Markdown Tax $ | Tax $ amount of the Perm Markdown Sales $ |
| Sales | Markdown $ | Perm Markdown value at time of Sales |
| Sales | Sales Before Markdown $ | Sales $ prior to the Perm Markdowns being deducted |
| Sales | Sales Before Markdown $ Incl GST | Sales $ prior to the Perm Markdowns being deducted (incl GST) |
| Sales | GP $ Before Markdown | GP$ of Perm Markdown Sales prior to Perm Markdowns being deducted |
| Sales | GP % Before Markdown | GP$ Before Perm Markdown as a % of Sales Before Perm Markdown $ |
| Sales | Markdown % Sales $ | % of Sales $ derived from products that had a permanent markdown applied at the time of the sale in the defined calendar period. Markdown Sales $ / Sales $ |
| Sales | Markdown % Sales $ Incl GST | % of Sales $ (incl GST) derived from products that had a permanent markdown applied at the time of the sale in the defined calendar period. Markdown Sales $ / Sales $ |
| Sales | Markdown % Sales Units | % of Sales Units derived from products that had a permanent markdown applied at the time of the sale in the defined calendar period. Markdown Units / Sales Units |
| Sales | Markdown ASP | Average Selling Price (ASP) of Sales $ derived from products that had a permanent markdown applied at the time of the sale in the defined calendar period. Markdown Sales $ / Markdown Units |
| Sales | Markdown COGS $ | COGS $ derived from products that had a permanent markdown applied at the time of the sale in the defined calendar period. |
| Sales | Markdown GP % | GP % derived from products that had a permanent markdown applied at the time of the sale in the defined calendar period. |
| Sales | Markdown GP $ | GP $ derived from products that had a permanent markdown applied at the time of the sale in the defined calendar period. |
| Sales | Markdown Sales $ | Sales $ derived from products that had a permanent markdown applied at the time of the sale in the defined calendar period. |
| Sales | Markdown Sales $ Incl GST | Sales $ (incl GST) derived from products that had a permanent markdown applied at the time of the sale in the defined calendar period. |
| Sales | Markdown Units | Sales Units derived from products that had a permanent markdown applied at the time of the sale in the defined calendar period. |
| Sales | Markdown # Sales Trnx | Distinct count of Sales transactions derived from products that had a permanent markdown applied at the time of the sale in the defined calendar period. |
| Sales | Markdown % Sales Trnx | Markdown Transactions as a % of Total Sales Transactions. Markdown # Sales Transactions / # Sales Transactions |
| Sales | Full Price % Sales $ | % of Sales $ derived from products that is considered Full Price at the time of the sale in the defined calendar period. Full Price Sales $ / Sales $ |
| Sales | Full Price % Sales $ Incl GST | % of Sales $ (incl GST) derived from products that is considered Full Price at the time of the sale in the defined calendar period. Full Price Sales $ / Sales $ |
| Sales | Full Price % Sales Units | Sales Units derived from products that is considered Full Price at the time of the sale in the defined calendar period. Full Price Sales Units / Sales Units |
| Sales | Full Price ASP | Average Selling Price (ASP) of Sales $ derived from products that are considered Full Price at the time of the sale in the defined calendar period. Full Price Sales $ / Full Price Units |
| Sales | Full Price COGS $ | COGS $ derived from products that are considered Full Price at the time of the sale in the defined calendar period. |
| Sales | Full Price GP % | GP% derived from products that are considered Full Price at the time of the sale in the defined calendar period. |
| Sales | Full Price GP $ | GP$ derived from products that are considered Full Price at the time of the sale in the defined calendar period. |
| Sales | Full Price Sales $ | Sales $ derived from products that are considered Full Price at the time of the sale in the defined calendar period. |
| Sales | Full Price Sales $ Incl GST | Sales $ (incl GST) derived from products that are considered Full Price at the time of the sale in the defined calendar period. |
| Sales | Full Price Units | Sales Units derived from products that are considered Full Price at the time of the sale in the defined calendar period. |
| Sales | Full Price # Sales Trnx | Distinct count of Sales transactions derived from products that are considered Full Price at the time of the sale in the defined calendar period. |
| Sales | Full Price % Sales Trnx | Full Price Transactions as a % of Total Sales Transactions. Full Price # Sales Transactions / # Sales Transactions |
| Sales | GP $ Before Temp Discount | GP$ of Temp Discounted Sales prior to Temp Discounted being deducted |
| Sales | GP % Before Temp Discount | GP$ Before Temp Discounted as a % of Sales Before Temp Discounted $ |
| Sales | Temp Discounted % Sales $ | Sales $ of Temp Discounted $ as a % of total Sales $ |
| Sales | Temp Discounted % Sales $ Incl GST | Sales $ of Temp Discounted $ (incl GST) as a % of total Sales $ (incl GST) |
| Sales | Temp Discounted % Sales Units | Sales Units of Temp Discounted as a % of total Sales Units |
| Sales | Temp Discounted ASP | Average Selling Price of the Temp Discounted Sales Transactions |
| Sales | Temp Discounted COGS $ | COGS $ of Temp Discounted Sales Transactions |
| Sales | Temp Discounted GP % | GP $ of Temp Discounted Sales as a % of Temp Discounted Sales $ |
| Sales | Temp Discounted GP $ | GP$ of Temp Discounted Sales Transactions |
| Sales | Temp Discounted Sales $ | Sales $ from Temp Discounted Transactions |
| Sales | Temp Discounted Sales $ Incl GST | Sales $ from Temp Discounted (incl GST) |
| Sales | Temp Discounted Units | Sales Units of Temp Discounted Transactions |
| Sales | Temp Discounted # Sales Trnx | # Temp Discounted Sales Transactions |
| Sales | Temp Discounted % Sales Trnx | # Temp Discounted Sales Transactions as a % of Total # Sales Transactions |
| Sales | Total Discount $ | Value of Total Discount applied to the transaction, i.e. Temp Discounted + Perm Markdown |
| Sales | Total Discount Tax $ | Value of Tax $ applied to Total Discounted Sales Transactions |
| Sales | Total Discount $ Incl GST | Value of Total Discount applied to the transaction (Incl GST) , i.e. Temp Discounted + Perm Markdown |
| Sales | Total Discount % | Total Discount $ value as a % of the Sales before Total Discount $ value |
| Sales | Sales Before Total Discount $ | Sales $ prior to Total Discounts (incl Temp and Perm) being deducted |
| Sales | Sales Before Total Discount $ Incl GST | Sales $ prior to Total Discounts (incl Temp and Perm) being deducted (Incl GST) |
| Sales | First Margin $ | GP $ of Sales Transactions prior to Total Discounts (incl Temp and Perm) being deducted |
| Sales | First Margin % | First Margin $ as a % of Sales Before Total Discount $ |
| Sales | Total Discounted % Sales $ | Sales $ of Total Discounted $ as a % of Total Sales $ |
| Sales | Total Discounted % Sales $ Incl GST | Sales $ of Total Discounted $ as a % of Total Sales $ (Incl GST) |
| Sales | Total Discounted % Sales Units | Sales Units of Total Discounted Sales as a % of Total Sales Units |
| Sales | Total Discounted ASP | Average Selling Price of the Total Discounted Sales Transactions |
| Sales | Total Discounted COGS $ | COGS $ of Total Discounted Sales Transactions |
| Sales | Total Discounted GP % | GP $ of Total Discounted Sales as a % of Total Discounted Sales $ |
| Sales | Total Discounted GP $ | GP$ of Total Discounted Sales Transactions |
| Sales | Total Discounted Sales $ | Sales $ from Total Discounted Transactions |
| Sales | Total Discounted Sales $ Incl GST | Sales $ from Total Discounted (incl GST) |
| Sales | Total Discounted Units | Sales Units of Total Discounted Transactions |
| Sales | Total Discounted # Sales Trnx | # Total Discounted Sales Transactions |
| Sales | Total Discounted % Sales Trnx | # Total Discounted Sales Transactions as a % of Total # Sales Transactions |
| Sales | Full Price Non Discounted % Sales $ | Sales $ of Non Discounted $ as a % of Total Sales $ |
| Sales | Full Price Non Discounted % Sales $ Incl GST | Sales $ of Non Discounted $ as a % of Total Sales $ (incl GST) |
| Sales | Full Price Non Discounted % Sales Units | Sales Units of Non Discounted Sales as a % of Total Sales Units |
| Sales | Full Price Non Discounted ASP | Average Selling Price of the Non Discounted Sales Transactions |
| Sales | Full Price Non Discounted COGS $ | COGS $ of Non Discounted Sales Transactions |
| Sales | Full Price Non Discounted GP % | GP $ of Non Discounted Sales as a % of Non Discounted Sales $ |
| Sales | Full Price Non Discounted GP $ | GP$ of Non Discounted Sales Transactions |
| Sales | Full Price Non Discounted Sales $ | Sales $ from Non Discounted Transactions |
| Sales | Full Price Non Discounted Sales $ Incl GST | Sales $ from Non Discounted (incl GST) |
| Sales | Full Price Non Discounted Units | Sales Units of Non Discounted Transactions |
| Sales | Full Price Non Discounted # Sales Trnx | # Non Discounted Sales Transactions |
| Sales | Full Price Non Discounted % Sales Trnx | # Non Discounted Sales Transactions as a % of Total # Sales Transactions |
| Sales | # Sales Trnx | Distinct count of Number of Sales Transactions |
| Sales | Units Per Transaction | The average number of Units Purchased in a Transaction |
| Sales | Units Per Transaction (All Salespeople) | The average number of Units Purchased in a Transaction for All Salespeople |
| Sales | Units Per Transaction (All Stores) | The average number of Units Purchased in a Transaction for All Stores |
| Sales | Avg Transaction Value | Average Transaction Value: Average Sales value for each Sales Transaction |
| Sales | Avg Transaction Value (All Salespeople) | Average Transaction Value for All Salespeople |
| Sales | Avg Transaction Value (All Stores) | Average Transaction Value for All Stores |
| Sales | Avg Transaction Value Incl GST | Average Transaction Value: Average Sales value for each Sales Transaction (Incl GST) |
| Sales | Avg Transaction Value Incl GST (All Salespeople) | Average Transaction Value for All Salespeople (incl GST) |
| Sales | Avg Transaction Value Incl GST (All Stores) | Average Transaction Value for All Stores (incl GST) |
| Sales | Avg Sell Price | Average Sale Price per Unit Sold |
| Sales | Avg Sell Price (All Salespeople) | Average Sale Price per Unit Sold for All Salespeople |
| Sales | Avg Sell Price (All Stores) | Average Sale Price per Unit Sold for All Stores |
| Sales | Avg Sell Price Pre Temp Discount | Average Sale Price of Temp Discount Transactions before any discount is applied |
| Sales | Avg Sell Price Pre Perm Markdown | Average Sale Price of Perm Discount Transactions before any discount is applied |
| Sales | Avg Sell Price Pre Total Discount | Average Sale Price of Total Discount Transactions before any discount is applied |
| Sales | Avg Sell Price Incl GST | Average Sale Price per Unit Sold (Incl GST) |
| Sales | Avg Sell Price Incl GST (All Salespeople) | Average Sale Price per Unit Sold for All Salespeople (Incl GST) |
| Sales | Avg Sell Price Incl GST (All Stores) | Average Sale Price per Unit Sold for All Stores (Incl GST) |
| Sales | Avg Sell Price Incl GST Pre Temp Discount | Average Sale Price of Temp Discount Transactions before any discount is applied (Incl GST) |
| Sales | Avg Sell Price Incl GST Pre Perm Markdown | Average Sale Price of Perm Discount Transactions before any discount is applied (Incl GST) |
| Sales | Avg Sell Price Incl GST Pre Total Discount | Average Sale Price of Total Discount Transactions before any discount is applied (Incl GST) |
| Sales | Online Sales $ | Sales $ of a Transaction in Locations defined as Online |
| Sales | Online % Sales $ | Sales $ where transactions are from Online Stores as a % of Total Sales $ |
| Sales | Online % Sales $ Incl GST | Sales $ (Incl GST) where transactions are from Online Stores as a % of Total Sales $ |
| Sales | Online % Sales Units | Sales Units where transactions are from Online Stores as a % of Total Sales Units |
| Sales | Online ASP | Average Sale Price per Unit Sold in Locations defined as Online |
| Sales | Online COGS $ | Total Sales at $ Cost of Goods Sold in Locations defined as Online |
| Sales | Online GP % | Gross Profit as a % of Sale $ in Locations defined as Online |
| Sales | Online GP $ | Gross Profit $ in Locations defined as Online: difference between Sales $ - COGS $ |
| Sales | Online Sales $ Incl GST | Sales $ (Incl GST) of a transaction in Locations defined as Online |
| Sales | Online Units | Units Sold in Locations defined as Online |
| Sales | Online # Sales Trnx | Number of Sales Transactions in Locations defined as Online |
| Sales | Online % Sales Trnx | # Online Sales Transactions as a % of Total # Sales Transactions |
| Sales | Online Average Transaction Value | Average Sales value for each Sales Transaction in Locations defined as Online |
| Sales | Online Avg Transaction Value Incl GST | Average Sales value (Incl GST) for each Sales Transaction in Locations defined as Online |
| Sales | Online Units Per Transaction | The average number of Units Purchased in a Transaction in Locations defined as Online |
| Sales | Online Temp Discount $ | Temp Discount value at time of Sales. incl both POS and Promo discount in Locations defined as Online |
| Sales | Online Temp Discount % | Temp Discount amount as a % of pre discount value at the time of sale in Locations defined as Online |
| Sales | Online Perm Markdown $ | Markdown value at time of Sales in Locations defined as Online |
| Sales | Online Perm Markdown Discount % | Perm markdown Sales $ as a % of Sales $ before Perm markdown amount deducted in Locations defined as Online |
| Sales | OnlineTotal Discount $ | Value of Total Discount applied to the transaction in Locations defined as Online, ie Temp Discounted + Perm Markdown |
| Sales | OnlineTotal Discount % | Total Discount $ value as a % of the Sales before Total Discount $ value in Locations defined as Online |
| Sales | Online Net Returns $ | Net Returns $ value after Returns and Sales (for eg Exchanges) in one Transaction in Locations defined as Online |
| Sales | Online Net Returns # Sales Trnx | # Net Returns Sales Transactions in Locations defined as Online |
| Sales | Online Net Returns % Sales Trnx | Net Returns Sales Transactions as a % of Sales Transactions in Locations defined as Online |
| Sales | Online Returns $ | Total $ value of the Returns Transaction in Locations defined as Online |
| Sales | Online Returns $ % | Returns $ as a % of the total Sales $ excluding Returns in Locations defined as Online |
| Sales | Online Returns # Sales Trnx | # Return Sales Transactions in Locations defined as Online |
| Sales | Online Net Returns Units | Net Returns Sales Units in Locations defined as Online |
| Sales | Online Returns Units | Total Units of the Returns Transaction in Locations defined as Online |
| Sales | # Selling SKUs | Count of the number of Style / Colour / Size level of a product available to sell |
| Sales | # Selling Stores | Count of the number of Stores available to sell |
| Sales | Sales $ Per store | Average Sales $ per Store with Sales Transactions |
| Sales | Units Sold Per Store | Average number of Units Sold per Store with Sales Transaction |
| Sales | Sales $ Per Sku | Average Sales $ per # Sales Transactions at the Style / Colour / Size level of a product |
| Sales | Units Sold Per Sku | Average Sales Units per # Sales Transactions at the Style / Colour / Size level of a product |
| Sales | Weeks Cover Units Last 4 Weeks | Calculates the weeks of Available Stock, based on the average Sales Units for the given time period |
| Sales | Weeks Cover Units Last 7 Days | Calculates the weeks of Available Stock, based on the average Sales Units for the given time period |
| Sales | Weeks Cover Units Last 8 Weeks | Calculates the weeks of Available Stock, based on the average Sales Units for the given time period |
| Sales | Weeks Cover Cost Last 4 Weeks | Calculates the weeks of Available Stock, based on the average Sales at Cost for the given time period |
| Sales | Weeks Cover Cost Last 7 Days | Calculates the weeks of Available Stock, based on the average Sales at Cost for the given time period |
| Sales | Weeks Cover Cost Last 8 Weeks | Calculates the weeks of Available Stock, based on the average Sales at Cost for the given time period |
| Sales | Weeks Cover Retail Last 4 Weeks | Calculates the weeks of Available Stock, based on the average Sales at Retail for the given time period |
| Sales | Weeks Cover Retail Last 7 Days | Calculates the weeks of Available Stock, based on the average Sales at Retail for the given time period |
| Sales | Weeks Cover Retail Last 8 Weeks | Calculates the weeks of Available Stock, based on the average Sales at Retail for the given time period |
| Sales | Sell Thru % Units | Sales units as a % of Opening Stock on Hand (calculated as Sales U + CSOH U) |
| Sales | Sell Thru % Units Accum | Lifetime Sales units as a % of Opening Stock on Hand (calculated as Sales U + CSOH U) |
| Sales | Sell Thru % Cost | Sales at COGS $ as a % of Opening Stock on Hand C$ (calculated as Sales C$ + CSOH C$) |
| Sales | Sell Thru % Cost Accum | Lifetime Sales at COGS $ as a % of Opening Stock on Hand (calculated as Sales C$ + CSOH C$) |
| Sales | Named # Sales Trnx | Distinct count of # Sales Transactions that have a Member ID attached to the Sales Transaction |
| Sales | Named # Sales Trnx (All Stores) | Distinct count of # Sales Transactions that have a Member ID attached to the Sales Transaction |
| Sales | Named % Sales Trnx | Sales Transactions that have a Member ID attached to the Sales Transaction as a % of Total # Sales Transactions. Named # Sales Trnx / # Sales Trnx |
| Sales | Named % Sales Trnx (All Salespeople) | Sales Transactions for all Salespeople that have a Member ID attached to the Sales Transaction as a % of Total # Sales Transactions. Best used to benchmark individual Salesperson results against all Salespeople result. Named # Sales Trnx (All Salespeople) / # Sales Trnx |
| Sales | Named % Sales Trnx (All Stores) | Sales Transactions that have a Member ID attached to the Sales Transaction as a % of Total # Sales Transactions. Best used to benchmark individual Stores results against all Stores result. Named # Sales Trnx (All Stores) / # Sales Trnx |
| Sales | Named # Sales Trnx with Email | Sales Transactions that have a Member ID (with an email recorded for that member) attached to the Sales Transaction as a % of Total # Sales Transactions. Named # Sales Trnx / # Sales Trnx |
| Sales | Named % Sales Trnx with Email | Sales Transactions that have a Member ID (with an email recorded for that member) attached to the Sales Transaction as a % of Total # Sales Transactions. Named # Sales Trnx / # Sales Trnx |
| Sales | Named % Sales Trnx with Email (All Salespeople) | Sales Transactions for all Salespeople that have a Member ID (with an email recorded for that member) attached to the Sales Transaction as a % of Total # Sales Transactions. Best used to benchmark individual Salesperson results against all Salespeople result. Named # Sales Trnx (All Salespeople) / # Sales Trnx |
| Sales | Named % Sales Trnx with Email (All Stores) | Sales Transactions that have a Member ID (with an email recorded for that member) attached to the Sales Transaction as a % of Total # Sales Transactions. Best used to benchmark individual Stores results against all Stores result. Named # Sales Trnx (All Stores) / # Sales Trnx |
| Sales | Unnamed # Sales Trnx | Distinct count of # Sales Transactions that do not have a Member ID attached to the Sales Transaction |
| Sales | Unnamed % Sales Trnx | Sales Transactions that do not have a Member ID attached to the Sales Transaction as a % of Total # Sales Transactions. Unnamed # Sales Trnx / # Sales Trnx |
| Sales | Named Sales $ | Sales $ that have a Member ID attached to the Sales Transaction |
| Sales | % Named Sales $ | Sales $ that have a Member ID attached to the Sales Transaction as a % of all Sales $ |
| Sales | Unnamed Sales $ | Sales $ that do not have a Member ID attached to the Sales Transaction |
| Sales | % Unnamed Sales $ | Sales $ that do not have a Member ID attached to the Sales Transaction as a % of all Sales $ |
| Sales | Named Sales Units | Sales Units that have a Member ID attached to the Sales Transaction |
| Sales | % Named Sales Units | Sales Units that have a Member ID attached to the Sales Transaction as a % of all Sales Units |
| Sales | Unnamed Sales Units | Sales Units that do not have a Member ID attached to the Sales Transaction |
| Sales | % Unnamed Sales Units | Sales Units that do not have a Member ID attached to the Sales Transaction as a % of all Sales Units |
| Sales | # Existing Named Sales Trnx | calculation of Named # Sales Trnx - # New Named Sales Trnx |