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!