View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Pivot Table - how to add column on the same row

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


Negda wrote:
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
Contextures
http://www.contextures.com/tiptech.html