sum/count in a pivot table formula

[ryanb.]

Is it possible to create a PivotTable formula that divides the sum of one
field by the count of another (i.e. divide Sales by the number of Invoices)?
I have other PivotTables where I put a dummy column in the data range that
allows me to get a "count", but this table is linked via ODBC and I would
like to do this automatically, not have to manually insert a count column
next to the ODBC data. I have been researching this, but everytime I create
a PivotTable formula, it sets it to SUM and does not allow that to be
changed.

v. XL XP
WIN2K

thanks,

ryanb.

 

[Peo Sjoblom]

If you have 150 invoices for "x" company and a total of that would be 11,250
now you drag the invoices to the row field, then drag invoices to data field
and get count of invoices and drag sales to data and get sum of sales. OK
now you right click somewhere in the sum fields and select field settings
and select average (or you can double click the sum of sales in the layout
and select average)? Or is it something I am missing?

 

[ryanb.]

I was wondering if you can do it via a calculated field because the all
functions except Sum are greyed out (no Count, no Avg, etc)? So then I
tried to do a calculated field and, that too, is greyed out (except for
Sum). It does this whenever I link directly to the data (and do not import
it into excel. Maybe it is our accounting package?