How to calculate values by using values in a different row?

[PETER_SUPPIPAT]

Dear Alteryx Community,

Is there a way to calculate values using values in a different row?  In this case, the forecasted Divisional Allocations should equal Operating & Maint Expense times -1.  It is different than turning the positive Op Exp into negative value within the same row.  Any help would be greatly appreciated.

Acct Category	2021 Budget	2022 Forecast	2023 Forecast	2024 Forecast	2025 Forecast	2026 Forecast	2027 Forecast	2028 Forecast	2029 Forecast	2030 Forecast
Operating Revenues
Operating & Maintenance Expense	1,328,093	1,372,476	1,418,394	1,460,946	1,504,775	1,549,918	1,596,415	1,644,308	1,693,637	1,744,446
Income from Operations	(1,328,093)	(1,372,476)	(1,418,394)	(1,460,946)	(1,504,775)	(1,549,918)	(1,596,415)	(1,644,308)	(1,693,637)	(1,744,446)
Corporate Allocations	-	-	-	-	-	-	-	-	-	-
Divisional Allocations	(1,328,093)	-	-	-	-	-	-	-	-	-
Total Allocations	(1,328,093)	-	-	-	-	-	-	-	-	-
Net Operating Income	-	1,372,476	1,418,394	1,460,946	1,504,775	1,549,918	1,596,415	1,644,308	1,693,637	1,744,446
Depreciation Expense	-	-	-	-	-	-	-	-	-	-
Net Income	-	1,372,476	1,418,394	1,460,946	1,504,775	1,549,918	1,596,415	1,644,308	1,693,637	1,744,446

[Qiu · Accepted solution]

@PETER_SUPPIPAT 
Lets just turn the rows into columns.

[PETER_SUPPIPAT]

Hi Qiu, That works great.  Thank you so much for your kind assistance with this.  Is there a way to reorder the row in a specific sequence?  The output file should have the below order.

[Qiu · Accepted solution]

@PETER_SUPPIPAT 
Added some small processing. 😁

[PETER_SUPPIPAT]

Qiu, This is great.  Thank you so much for taking your time to put together the workflows and sharing your knowledge with me.  I found this very useful.  Your help is greatly appreciated.

[Qiu]

@PETER_SUPPIPAT 
Glad to hep and thank you for the warm word 😁