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
|