Need help in Sum the columns while rows getting append

[Gaurav0001]

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

[Raj]

@Gaurav0001 does your input have the blank row and number?

[Gaurav0001]

Hey @Raj , 
If possible, Can you please provide me a workflow with the Data I provided as an Example Table.

[Gaurav0001]

My Input only contains the Name field and the Amount fields.

In Output, I need to sum the columns in a specific cell position leaving one row blank above.(As its showing on my Examples.)

[Raj]

@Gaurav0001 almost done sharing in 2 min.

[Qiu]

@Gaurav0001 
Now sure what you mena by "Specific Postion" in Alteryx? 🤣
Anyway, a quick sample

[Raj]

@Gaurav0001 Bit messy but works dynamically>

like the solutions and mark as done if meet your expectations,

[Raj]

@Qiu What i understood was he was trying to enter the value in specific column, might be Wrong but made it

[Raj]

@Gaurav0001 first part is complete , second part calculation is added you just need to replicate what is done for formatting. Which is a easy part
let us know in case of any queries.