If the problems are unique they are each totaled. So what exactly are you
subtotalling? And since you are alluding to a rolling 13 week result what
version of Excel are you using?

--
Thanks,
Shane Devenshire


"Kompu Kid" wrote:

Hello All:

I am presenting rolling 13 weeks of data on various manufacturing
problemin our operations with a pivot chart. On the chart I would like
to show the subtotals for each problem as well but I cannot figure
out a way of doing this.

Any suggestions?

Thanks!

Deguza

----------------------------------- Sample pivot chart
---------------------------------------



Sum of Qty
Product Problem Week Total
Blue_gadget Assembly error 2007 12
2007 14
2007 13
2007 15
2007 16 18
2007 17 4
2007 19
2007 20 6
2007 18 10
2007 21
2007 22
2007 23
2007 24
Assembly error Total 38

[...]

Damaged part 2007 12
2007 14
2007 13
2007 15
2007 16
2007 17
2007 19
2007 20 13
2007 18
2007 21
2007 22
2007 23
2007 24
Damaged part Total 13