|
Pivot Table - how to add column on the same row
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 |
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 |
Pivot Table - how to add column on the same row
On Apr 5, 7:32*am, Debra Dalgleish wrote:
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 Contextureshttp://www.contextures.com/tiptech.html- Hide quoted text - - Show quoted text - Thanks Debra - it works! Negda |
| All times are GMT +1. The time now is 02:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com