Multi-row replace with condition

[BosKev]

Hello All,

I want to replace the rows above in a table with the total , what would be the formula for this in a multi row tool? Thanks.

example below, I want to replace Employee A, B's "Total"with the number 27.

Employee	Total
A	18
B	9
Total	27

[benakesh · Accepted solution]

Hi @BosKev ,

Sort and use iif([Employee] = 'Total' , [Total] , [Row-1:Total])  in multi row formula .

[BosKev]

Hi @benakesh ,

Can you explain the use of sort ? also I didn't have additional rows you created. I got the following...I skipped the sort function because the total will always be larger than the rows above. Thanks.

Employee	Total
A	0
B	0
Total	27

[BosKev]

Thanks, I got it working.