Hello all

I believe I know the answer, in that it cant be done, hoping I am wrong.

I have a lot of data where pivots work fine, and I can successfully use the average of field 1 (for example) to get what I need.

Next however, is I need to sum those averages. What I want to do is for the pivot sub total to actually "sum" the field 1 average results, not be an average itself.

I have a feeling instead I need to do this in the source data instead.

Appreciate any ideas.

Cheers