I am trying to get a weighted average of each CPT in my Pivot Table for Excel 2007. Can anyone help me? Please keep you answers in simple terms (I am not as experienced). I'm also new to the website, so I apologize if this is posted incorrectly! Here is what my pivot table shows (The XXXX represents the weighted average I am trying to show):
Row Labels Values
# Units Ext Price (#Unit*Price)
CPT 1 - HMO - Fac 2 100
CPT 1 - HMO - NF 3 300
CPT 1 - PPO - Fac 1 100
CPT 1 - PPO - NF 1 100
Subtotal 7 XXXX
CPT 2 - HMO - Fac 2 40
CPT 2 - HMO - NF 1 50
CPT 2 - PPO - Fac 1 60
CPT 2 - PPO - NF 2 80
Subtotal 6 XXXX
Thanks in advance!
Row Labels Values
# Units Ext Price (#Unit*Price)
CPT 1 - HMO - Fac 2 100
CPT 1 - HMO - NF 3 300
CPT 1 - PPO - Fac 1 100
CPT 1 - PPO - NF 1 100
Subtotal 7 XXXX
CPT 2 - HMO - Fac 2 40
CPT 2 - HMO - NF 1 50
CPT 2 - PPO - Fac 1 60
CPT 2 - PPO - NF 2 80
Subtotal 6 XXXX
Thanks in advance!
