i have 2 charts in a QVW with a formula to get the avg score, 1 is by employee, period, dept (pivot table) and the other is a summary by dept (straight table)
if you keep the selections as is and export the pivot table to excel, the total column sums to 89.735 and averages to 3.09.
i am trying to get 3.09 into the summay staight table but i can't seem to get it to wok.
is anyone able to help please?
the summary table will still need to calculate correctly when the selections are removed and it shows all depts.
