Platform: Enolytics DTC

Summary:

What it calculates: Tracks the total dollar value of fulfilled wine orders during your selected time period, focusing specifically on orders where Order Status = 'Completed', Payment Status IN ('Paid', 'Refunded', 'External'), and Is Shipped = '' (indicating fulfillment rather than shipping). This gives you a clear picture of revenue from orders that have been processed and fulfilled at your facility, whether they're heading to customers or being picked up.

Variants:
• CP: Current period fulfilled sales
• PP: Prior period fulfilled sales
• Δ: Dollar change in fulfilled sales between periods
• Δ%: Percentage change in fulfilled sales

How to use it:
• Compare with Shipped Sales to understand your fulfillment pipeline — if fulfilled sales are significantly higher than shipped sales, you might have a backlog of orders ready to go out
• Track fulfillment performance during busy seasons to ensure your operations team is keeping pace with demand, especially useful for wine club release periods

Related measures: Shipped Sales

Tip: The distinction between fulfilled and shipped matters most during high-volume periods — fulfilled orders represent work completed by your team, while shipped orders represent customer satisfaction delivered.

Note: Parts of this article were generated with AI and may not be perfect. If something looks off or could be better, click the 😞 below — it opens a quick chat so you can let us know.

Quick Stats:

Type: Sum/Total
Build Beyond Limits Group: Σ Fulfilled Sales

Fulfilled Sales CP

🔢 Formula

m₁
with:
m₁ = Sum([Order Items].[Quantity] × [Order Items].[Sold Price])
    WHERE
        [Order Items].[Order Status] = 'Completed'
        AND [Order Items].[Payment Status] IN ('Paid', 'Refunded', 'External')
        AND [Orders].[Fulfilled Date] ≥ 'Start of Current Period'
        AND [Orders].[Fulfilled Date] ≤ 'End of Current Period'
        AND [Orders].[Is Shipped] = true

Output Format: $#,###.00

Formula Last Updated: 2026-03-25T16:04:51Z

Fulfilled Sales PP

🔢 Formula

m₁
with:
m₁ = Sum([Order Items].[Quantity] × [Order Items].[Sold Price])
    WHERE
        [Order Items].[Order Status] = 'Completed'
        AND [Order Items].[Payment Status] IN ('Paid', 'Refunded', 'External')
        AND [Orders].[Fulfilled Date] ≥ 'Start of Previous Period'
        AND [Orders].[Fulfilled Date] ≤ 'End of Previous Period'
        AND [Orders].[Is Shipped] = true

Output Format: $#,###.00

Formula Last Updated: 2026-03-25T16:12:34Z