macros in pivot table
 

I realize I may not have been too clear on my last post. But does anyone know
code that can change a grand total sum to an average total in a multiple
consolidated pivot table?
For example:

dept comm %
sales $14.15 30%
HR $21.25 16%
HT $36.78 1.2%
$72.18 47% wrong answer(this is what I'm getting)
16% should be this one (the average of the column).

When I try and do the field settings it gives me this error:
Averages, standard deviation, variances are not supported when a pivot table
has multiple calculated fields.
So I was trying to get code for a macro that would override this error and
change the to the correct totals.
thanks in advance