SELECT Year, 
            ROUND(SUM(Sales) OVER (PARTITION BY Year),0)/1000 AS Y_Sales,
            ROUND(SUM(Sales) OVER(),0)/1000 AS All_Y_Sales
FROM (
            SELECT calendaryear Year, SUM(transactionprice*quantity) AS Sales
            FROM factonlinesales fos INNER JOIN dimdate dd
                ON fos.orderdatekey= dd.datekey
            GROUP BY calendaryear
            )
ORDER BY 1  ;