Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Oh, btw, Input, Defect, FPY and KDPM are all expressions in the pivot table.
Josh
Hi Josh,
write the exp in expressions tab you can achieve.
Regards
Sathish
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?
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