How to create calculated expression in pivot table?

Wed, 03 Sep 2014 10:28:27 GMT

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.

Re: How to create calculated expression in pivot table?

MK_QSL — Wed, 03 Sep 2014 10:50:57 GMT

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;