Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table column appear as 0 | Excel Discussion (Misc queries) | |||
Sorting a Pivot Table Column that is not the first column... | Excel Worksheet Functions | |||
Pivot table add one column | Charts and Charting in Excel | |||
pivot table, how to add 1 column only | Excel Discussion (Misc queries) | |||
pivot table, How to add 1 column | Charts and Charting in Excel |