Pasting a pivot table into values, allowing me to edit the numbers, while maintaing the subtotal/grandtotal sum formula

[fanthor]

I am not sure if this is possible

I have this table:

https://imgur.com/jqTb0Th

Is it possible for me to paste this table into value, allowing me to edit the numbers for T0 and T1, while still maintaining the subtotal/grandtotal formula?

Something like this

https://imgur.com/eNtyspD

Thank you so much for the help

The imgur is just a quick pivot i made, the actual pivot table have dozens of subtotals for rows/columns

Currently the process is a person pastes the Pivot table into values

• and then manually writes B3+B4 and so on for all the subtotal boxes
• and then we can start work with manual injections of funds

I'm basically expecting

1. Creation of Pivot Table for presentation of data
2. Kill the link
3. nothing from the Pivot table format except for the data and sub/grand total formula
   
   
   

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	DATA					Pivot				Expected result(green with formula)
2	Description	Funds	Amount			Row Labels	Sum of Amount			Row Labels	Sum of Amount
3	FUND SHARES	T0	11444			FUND CAPITAL	100			FUND CAPITAL	100
4	FUND CAPITAL	T1	100			T1	100			T1	100
5	FUND SHARES	T1	231			FUND SHARES	14675			FUND SHARES	14675
6	FUND SHARES	T2	3000			T0	11444			T0	11444
7						T1	231			T1	231
8						T2	3000			T2	3000
9						Grand Total	14775			Grand Total	14675
10
Sheet1

Cell Formulas
Range	Formula
K3	K3	=SUM(K4)
K5	K5	=SUM(K6:K8)
K9	K9	=SUM(K6:K8)