Thank you everyone for your help. Looks good with both solution.

yes that is right two consecutive  previous months.

Thank you every one it work the way you guys told me. Appreciate all your help.

There is no way i can do in SQL so i wrote SP now it is working.

Thanks for the input.

Thanks for output but change in the requirement so this will not work.

This is new requirement i got it.

Thank you everyone works the way i want.

Ok Thanks.

Here is updated excel this is what I need it that why i have formula

calculated by adding all the transfers in and subtracting all the transfers out from the previous

account...

Thanks but this one not working as excpeted.

Sorry again

For first month balance is trans in 12962.04- 7802.66 trans out = 5159.38

For second month balance is trans in 14966.54  - ( first month of balance which is 5159.38...

• This reply was modified 2 years, 6 months ago by  sks_989.
• This reply was modified 2 years, 6 months ago by  sks_989.

sorry Phil my bad. here is create of table and insert data

CREATE TABLE [dbo].[final_data](

[account_id] [varchar](50) NULL,

[tran_in] [decimal](38, 2) NOT NULL,

[tran_out] [decimal](38, 2) NOT NULL,

[Month_Cal] [int] NULL,

[Year_cal] [int] NULL

) ON [PRIMARY]

GO

INSERT...

File attacted

Thanks Mark. Really appreciate for fast response. Really help me.

Thank you very much i need it like way without cross apply and it work perfectly as you maintain. I really appreciate it.

is there any other way if anyone knows.