How to add a new calculated column

Question

HI, I want to add and an acumulative values in a new “Accumulative” Column from SUMA_PROFIT column, begins from last record. for example: last record value 1714703269481.14 + penultimate record value 1228973052365.97 and so... Do i explained well?? Thank u MATES

Amit Kumar · Answer

Hi, you can use calculate total using Group by and rollup. See the below link it is running. https://www.dotnettechpoint.com/2018/03/calculate-final-total-in-sql-server.html?m=1

Bidyasagar Mishra · Answer

Hi Ramon, Follow the below link https://dba.stackexchange.com/questions/181773/sum-of-previous-n-number-of-columns-based-on-some-category

Ramon Quintana · Answer

Hi Amit, That is a good Clause, but it works to get Sub-Totals only, What I want is to know how to get a Accumulative column. I have been trying with this: sum(Query_Base.profit_center_local_currency) OVER (PARTITION BY Query_Base.Cuentas_Maestro_Numero_cuenta,Query_Base.Fiscal_Year--,Query_Base.Period ORDER BY Query_Base.Cuentas_Maestro_Numero_cuenta,Query_Base.Fiscal_Year,Query_Base.Period ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS Acumulado It seen to works fine, but if you know some else clause please let me it know. Really Thank u..

Bidyasagar Mishra · Answer

can you describe more ?

Ramon Quintana · Answer

Hi, Just i want to create a new column from sum accumulative values begins from last record For example: 1963362209725.44 + 1565215511404.92 + etc Until first record´s table