Catarina,
Yes, you can use Subtotals, but you don't add them to the pivot table, you
need to go back to the list. If the Subtotals option is still greyed out, and
you're using Excel 2003, you need to convert your list back to a range.

In the list, Sort on the column that you want to subtotal the list by, then
Data|Subtotals. Choose the column that you just sorted by in the 'At each
change in', then choose the sum function and put ticks in the required 'Add
subtotals to' columns. Click OK. Then do the same again for the average, but
before you click OK, remove the tick from the 'Replace current subtotals' box.
--
Hope this helps,
MarkN


"catarina_miguel" wrote:

Hi there,
I'm trying to construct a pivot table where I'd like to display both the sum
total for a column, AND THEN the average directly below it.

I can do it by dragging the field into the data area a second time, but then
I'm listing duplicate amounts for all but the total (which is a sum total in
one column and an average in the next). I'd like to avoid that replication if
possible.

Someone told me I could do it using Subtotals ... but that option is grayed
out.

Thanks for any advice you can provide!