Hello,
I need help, If we receive rows daily and its getting increased by + 1 or + Infinity.
Then how we Sum up the column and get the total in specific cell position.
Scenario 1 :
For Example,
Below table contains amount and its get added in a specific cell position (Leaving one row blank above).
Amount get added from columns (10+20+10 = 40)
| Name | P-Amount | O-Amount | T-Amount |
| ABC | 10 | 20 | 10 |
| | | | |
| | | 40 | |
Amount added in specific cell position : (10+20+10+20+10+30 = 100 )
| Name | P-Amount | O-Amount | T-Amount |
| ABC | 10 | 20 | 10 |
| BCD | 20 | 10 | 30 |
| | | | |
| | | 100 | |
Amount added in specific cell position : (10+20+10+20+10+30+10+5+40 = 155 )
| Name | P-Amount | O-Amount | T-Amount |
| ABC | 10 | 20 | 10 |
| BCD | 20 | 10 | 30 |
| CDE | 10 | 5 | 40 |
| | | | |
| | | 155 | |
As above, the rows are getting increased continuously and the particular columns amounts gets added and sum it in a specific cell position leaving one row blank above.(sum of cell position is also getting changed whenever rows get increased)
I need help to make a workflow which add selected columns and sum it in a specific cell position leaving one blank row above.
Scenario 2 :
Need help to add the last/latest rows and sum it in specific cell position.
For Example :
Amount get added from columns (10+20+10 = 40)
| Name | P-Amount | O-Amount | T-Amount |
| ABC | 10 | 20 | 10 |
| | | | |
| | | 40 | |
Amount added in specific cell position : (20+10+30 = 60 )
| Name | P-Amount | O-Amount | T-Amount |
| ABC | 10 | 20 | 10 |
| BCD | 20 | 10 | 30 |
| | | | |
| | | 60 | |
Amount added in specific cell position : (10+5+40 = 55 )
| Name | P-Amount | O-Amount | T-Amount |
| ABC | 10 | 20 | 10 |
| BCD | 20 | 10 | 30 |
| CDE | 10 | 5 | 40 |
| | | | |
| | | 55 | |
