Pivot Table

[bodylojohn]

Hi everybody.

I have a pivottable query.
This works great.

I have a column with averages.
This works great to.

Now here is my problem:
At the bottom of my Averages column there is a total (sum)

I want an average in stead of a sum.

Please help me guys....

Thank you very very much in advance...

 

[Rickster57]

Average

The statement AVG([afield]) didn't work but SUM did?

Hope this helps.

 

[bodylojohn]

Hello Rickster...

How can I change this??????
I mean...where can I change the grand total to AVG??
Because if I insert grand totals it only shows the SUM...

Help help help...

and thanks so far

 

[neileg]

The average of a set of averages is not a mathematically valid value except in very rare occassions.