Pivot Table - how to add column on the same row

[Negda]

I created a table:


Sum of ×¡×›×•× ×‘×©×§×œ×™× ×—×•×“×© (X)
Custmer# 2007/10 2007/11 2007/12 2008/01 Grand Total
100001 12,838 12,838
100002 8,143 8,143
100003 1,424 1,411 14,597 17,432
100005 25,102 12,407 3,576 41,085
Grand Tota 12,838 34,668 13,818 18,173 79,498


now I want to add the Name column and I got the name on diferent row:


Sum of ×¡×›×•× ×‘×©×§×œ×™× ×—×•×“×© (X)
Customer# Name 2007/10 2007/11 2007/12 2008/01 Grand Total
100001 SES 12,838 12,838
100001 Total 12,838 12,838
100002 Omega 8,143 8,143
100002 Total 8,143 8,143
100003 Systems 1,424 1,411 14,597 17,432
100003 Total 1,424 1,411 14,597 17,432
100005 Gal 25,102 12,407 3,576 41,085
100005 Total 25,102 12,407 3,576 41,085
Grand Total 12,838 34,668 13,818 18,173 79,498

How I can get it in one row (without sub total row)?

Thanks,
NK

 

[Debra Dalgleish]

To hide the subtotals:
Double-click on the Customer# field button
Under Subtotals, click None, then click OK