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
Bookmarks