• You can roll up selected values and add them to each record like this:

    SELECT Country,Region, Current_Forecast,

    SUM(Current_Forecast) OVER (PARTITION BY Country, Region) as Sum_Current_Forecast

    FROM My_Table