Hi everyone,

Is it possible in a PIVOT to include in a column a Sum by the Subtotal of a column? The subtotals are showing the AVERAGE when I would like a sum of the Average numbers?

I have a list of products with an Average price and would like to total the average price by the category of products?

Product Group A Subtotal = 4
Av. Price A 1
Av. Price B 1
Av. Price C 1
Av. Price D 1

At the moment I get the Average so product group A = 1 but I would like to see a sum of this.

Any help would be great.

Thanks!

Adele