CREATE VIEW [dbo].[vw_orderAnalytics]
    AS SELECT
      ISNULL(ROW_NUMBER() OVER (ORDER BY DATEPART(ISO_WEEK, [DateCreated]) desc), -1)   AS Id,
      DATEPART(ISO_WEEK, [DateCreated])                                                 AS Week,
      COUNT(*)                                                                          AS Count,
      SUM(ISNULL(NULLIF([PriceCorrected], 0), Price))                                   AS Price,
      SUM([MarginAbsolute])                                                             AS Margin,
      (
            SELECT
                SUM(ISNULL(NULLIF([PriceCorrected], 0), Price))
            FROM [dbo].els_orders

            INNER JOIN [dbo].[els_orderPaymentStatuses] os
            on els_orders.PaymentStatusID = os.id

            WHERE
                os.Code = 'Cancelled'
                AND
                DATEPART(ISO_WEEK, els_orders.[DateCreated]) = DATEPART(ISO_WEEK, o.[DateCreated])
      )                                                                                 AS Canceled
  FROM [dbo].[els_orders] o
  GROUP BY DATEPART(ISO_WEEK, [DateCreated])