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

    multiply total in a Pivot table

    Josh Chang

      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,

      KDPM_q.PNG

      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