Pivot table calc using average in summed field

C

cereldine

Hi, i have drawn a substantial amount of data off an sql server fo
analysis in pivot tables. My data would resemble something like below

Reg Field A Field B Field C Field D
1 12 4 2 0
1 12 4 6 2

1 12 4 3 1

My Formula should something like

Comparrison = Average of B + (All of C values - All of D values)

I can't quite get this to work ina calculated field, How would i pu
this as an expression in a calculated field? My experiments have alway
treated B as a summed amount so i would end up with

Comparrison = 12 (sum of B not average) + (11-3) Not
Comparrison = 4 + (11-3)

Thank
 
Top