How do I get profit percentage in pivot table ?

[lemonteadrink]

How do I get profit percentage in pivot table ? There is contract sum and cost.​

 

[sheetspread]

One way is a calculated field:

Excel 2010
	A	B	C	D	E	F	G	H
1	Project	Contract Sum	Cost		Row Labels	Sum of Contract Sum	Sum of Cost	Sum of Field1
2	Q	5929	3355		E	3510	1200	65.81%
3	W	5194	1482		I	4653	698	85.00%
4	E	3510	1200		O	12329	6085	50.64%
5	R	8113	6957		Q	5929	3355	43.41%
6	T	9361	6194		R	8113	6957	14.25%
7	Y	3847	1807		T	9361	6194	33.83%
8	U	9828	3952		U	9828	3952	59.79%
9	I	4653	698		W	5194	1482	71.47%
10	O	12329	6085		Y	3847	1807	53.03%
Sheet6