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

    multiply total in a Pivot table

    Josh Chang



      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?