Pivotable - Totals & Subtotals Calc Query

[Frank]

Hi,

I'm using a pivot table with 2 columns of data. 1 col. is just a
straight item count while the other is a calculation of the item *
price (where price and item are cols. on the source data table. The
subtotal for the "item" col. is OK but the subtotal for the calculated
col is wrong (it is in fact the sum of the item col. * sum of "price"
col. from the osurce table.

Any ideas how I can make the subtotal be the expected sum of the
calculated col.?

Cheers,

Frank.