How to create expression in pivot table?

[#1]

Hi ,

please find the below excel table

now i want create output column

if FCC=DCC if values are matching i want add all the matching vaues sum to output column

for example in FCC column  four 7081 values are there

the sum of 7081 value is 7000

now i want add this sum to DCC Column, in DCC  Column So many 7081

when ever 7081 is there i wnat add 7000 .

for all the values same logic

for example  in FCC column 157602 is there but in DCC Column no 157602 for that i want to show zero values

and also i want to show zero if not matching.

DCC	FCC	State	Amount	Output
7042	157602	a	10000	0
7053	7081	b	5000	0
7055	157840	c	3000	0
7057	7081	d	-220	0
7057	7081	e	-1780	0
7080	7081	f	4000	0
7081	121083	g	1374.6	7000
7081	17407	h	1354.2	7000
7081	415878	u	739.8	7000
7081	4245	i	489.6	7000
7081	37881	k	73.2	7000
7081	80529	l	604.2	7000
7081	412053	m	104.4	7000
7081	424849	n	791.4	7000
7081	425549	f	468.6	7000

[#2]

1