Pivot table subtotals by Customer code

Dear Gurus,
How do I put subtotals in column K at each change of customer code?
Thank you!

I am working in 2003 and attached the spreadsheet in question.

Originally Posted by Søren Larsen

One way is to put the following in K2:

=SUMIF($A$2:$A$36,A2,$J$2:$J$36) and copy down

Hi Søren,
This didn't seem to work. It just shows the number on the first row in each Customer Code group, so for CM5, it shows 69.55
Any modification of this code?
Thank you,
Eva

Originally Posted by Søren Larsen

It should work... have a look at the attached:

What if I want the result as a subtotal at each change of customer code? Now, it shows the subtotal three times. Thanks!

Hi,
See attached the pivot table with the amount in the sum value
Parameters of Cust_Code > Layout and printing > Show items in outline form
Activate the check box : Display labels next field in the same column and Display subtotals above each group
Hope this helps and work for Execl 2003
Best regards

Originally Posted by Søren Larsen

In that case, you can change the code to:

=IF(A2<>A3;SUMIF($A$2:$A$36,A2,$J$2:$J$36) ,"")

But then your codes have to be sorted consecutively.

Thank you!