J
JB
Hello,
I have a large pivot table in the format as shown at the bottom of
this post. I simply want to add a calculated field to the table for
each function that multiplies "Avg%Compt" by "Avg hours" for each MS#,
done for each Funct within each Subtype within each Type. ie MS1 for
Type A, Subtype 1. Funct ab, = 2.382 (60%*3.97) and MS2 = .5955
(15%*3.97) etc.
I cannot get this to happen. Can anyone show me how to set this
formula up?
Thanks
JBESr
Type Subtype Funct Data MS1 MS2 MS3 MS4
A 1 ab Avg%Compt 60% 15% 15% 10%
A 1 ab NumPermits 301 301 301 301
A 1 ab Avg hours 3.97 3.97 3.97 3.97
A 1 ab Calc'ed Field ?? ?? ??
A 1 cd Avg%Compt
A 1 cd NumPermits
A 1 cd Avg hours
A 1 cd
I have a large pivot table in the format as shown at the bottom of
this post. I simply want to add a calculated field to the table for
each function that multiplies "Avg%Compt" by "Avg hours" for each MS#,
done for each Funct within each Subtype within each Type. ie MS1 for
Type A, Subtype 1. Funct ab, = 2.382 (60%*3.97) and MS2 = .5955
(15%*3.97) etc.
I cannot get this to happen. Can anyone show me how to set this
formula up?
Thanks
JBESr
Type Subtype Funct Data MS1 MS2 MS3 MS4
A 1 ab Avg%Compt 60% 15% 15% 10%
A 1 ab NumPermits 301 301 301 301
A 1 ab Avg hours 3.97 3.97 3.97 3.97
A 1 ab Calc'ed Field ?? ?? ??
A 1 cd Avg%Compt
A 1 cd NumPermits
A 1 cd Avg hours
A 1 cd