multiply total in a Pivot table

[Anonymous]

Hello,

I have a pivot table which has two dimensions, products, process_group and four expressions, Input, Defect FPY and KDPM.

Now I would like to create one more column which is the term of multiplication of all three FPY under each DIP, FA and SMT dimensions.

For example,

The red box is what I want add to this pivot table, and it is the term of all FPY. i.e. 98.85%*100.00%*97.87%=98.69% for SMA200.

How to do this?

thanks,

Josh

[Anonymous]

Oh, btw, Input, Defect, FPY and KDPM are all expressions in the pivot table.

Josh

[satheshreddy]

Hi Josh,

write the exp in expressions tab you can achieve.

Regards

Sathish

[sunny_talwar]

So in way you are looking for a total for FPY and NOT the same number (98.69%) repeating under each process_group (DIP, FA, SMT)? or do you want a same number repeating under each process_group?

[Anonymous]

Sunny,

Not repeating under each process_group.

And, I want to reuse the expression FPY to calculate the multiplication of DIP.FPY * SMT.FPY * FA.FPY.

Thanks,

Josh