Multi-field Calculations, Multi-row Calculation

[Joy1]

Hi, 

I am trying to do operations on hundreds of fields. Here is a simplified example of what I am trying to achieve:

	Jan 2018 - Company A Revenue	Feb 2018 - Company A Revenue	March 2018 - Company A Revenue	Jan 2018 - Company B Revenue	Feb 2018 - Company B Revenue	March 2018 - Company C Revenue	Total For Jan	Total For Feb	Total For Mar
Big Accounts	68	95	50	56	85	100	124	180	150
Medium Accounts	44	17	86	65	79	97	109	96	183
Small Accounts	81	86	53	21	7	29	102	93	82

The idea here is that:

Field 7 (Total Jan)= Field 1 + Field 4

Field 8 (Total Feb)= Field 2 + Field 5

Field 9 (Total Mar)= Field 3 + Field 6

The Equation itself is a bit more complex. The obvious way to do it is to create three different equations for the three fields. Except in my case it will be 100s of equations. On excel I could just drag the equation and get all the rest.

Ideally, we can do an iterative equation as follows:

Field x = Field x-6  + Field x-3

The problem is that the multi-field formula only has current field with no option manipulate the index otherwise

Another option is to transpose the matrix and try to apply the multi-row formula equations. However, I failed to be able to achieve this. 

Any help is much appreciated. I am fairly new to Alterix so bare with me please!!

[Joy1]

Impressive solutions! It seems to be such a tough task for things excel could do in a second. I guess while loops and column indices are non-existent here, which complicates everything.

Anyway, thanks for the support! I really appreciate it. Let me know if you come up with a more simplistic approach though.

Take care