How to create calculated 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

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

[MK_QSL]

Temp:

Load * Inline

[

  DCC, FCC, State, Amount

  7042, 157602, a, 10000

  7053, 7081, b, 5000

  7055, 157840, c, 3000

  7057, 7081, d, -220

  7057, 7081, e, -1780

  7080, 7081, f, 4000

  7081, 121083, g, 1374.6

  7081, 17407, h, 1354.2

  7081, 415878, u, 739.8

  7081, 4245, i, 489.6

  7081, 37881, k, 73.2

  7081, 80529, l, 604.2

  7081, 412053, m, 104.4

  7081, 424849, n, 791.4

  7081, 425549, f, 468.6

];

Join

Load FCC,

  COUNT(FCC) as TotalFCC

Resident Temp

Group By FCC;

Join

Load FCC as DCC,

  SUM(Amount)

Resident Temp

Where TotalFCC > 1

Group By FCC;

Drop Field TotalFCC;