Need Equivalent of Pivot table"Field Settings" from Excel

K

Katie Mac

In an Excel pivot table, you can right click on a column
in the pivot table, select Field Settings and change the
column from "Count" to "Average" (for example). I am
wanting to be able to do this in Access, but can't find
how...

I have 4 columns in my data area of my access pivot
table:
Count of Cases, Count of Age, Sum of Last Edit and Sum ot
Cooked

I want the middle two columns to actually be Averages
rather than Count or Sum. Is there a way to get this to
happen in a pivot table without exporting to Excel?

Thanks
 
Top