How Can I Do Average in PivotTable

Y

Yu

In Excel 2002 version, I am unable to do average in the
PivotTable. I was told "Average, Standrad deviation, and
variance are not supported when a PivotTable has
calculated items." I used the same function before with
the older Excel version. I think one of the good things is
we can calculate average in the Pivot Table with other
calculated items. Any one knows how to solve the problem?

Thanks
 
Top