SUM диапазон ячеек после применения определенной пользователем функции к каждой ячейке

Попробуйте выполнить запрос:

SELECT city ,
       'Final' AS Type ,
       t.month ,
       t.Value
FROM   (   SELECT city ,
                  [type] ,
                  [month] ,
                  SUM(value) OVER ( PARTITION BY city
                                    ORDER BY type ,
                                             month ) AS Value
           FROM   #cities ) t
WHERE  t.type = 'Push';

Результат:

+-------+-------+-------+-------+
| city  | Type  | month | Value |
+-------+-------+-------+-------+
| one   | Final |     0 |   215 |
| one   | Final |     1 |   216 |
| one   | Final |     2 |   210 |
| one   | Final |     3 |   210 |
| three | Final |     0 |   404 |
| three | Final |     1 |   409 |
| three | Final |     2 |   401 |
| three | Final |     3 |   401 |
| two   | Final |     0 |   358 |
| two   | Final |     1 |   362 |
| two   | Final |     2 |   357 |
| two   | Final |     3 |   362 |
+-------+-------+-------+-------+