PivotTable - Totals & Sub Totals 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.

 

[Debra Dalgleish]

To get an accurate total, you can multiply item * price for each row in
the source data table. Then add the Total column to the pivot table.