4 Replies Latest reply: Feb 16, 2017 12:47 PM by Josh Chang

# multiply total in a Pivot table

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

• ###### Re: multiply total in a Pivot table

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

Josh

• ###### Re: multiply total in a Pivot table

Hi Josh,

write the exp in expressions tab you can achieve.

Regards

Sathish

• ###### Re: multiply total in a Pivot table

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?

• ###### Re: multiply total in a Pivot table

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