How to create expression in pivot table?

Thu, 11 Sep 2014 13:22:23 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

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.

Re: How to create expression in pivot table?

Thu, 11 Sep 2014 13:41:30 GMT