 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2007Pivot Table Display Question
Please excuse me if this is a very simple question, however I can't seem to figure it out: I have a pivot table whose data looks like the following RELEASE # JURISDICTION REVENUE 00000 Germany 5,000 Britain 1,000 France 2,000 00001 Germany 5,100 I would like the pivot table to display like this: RELEASE # JURISDICTION REVENUE 00000 Germany 5,000 00000 Britain 1,000 00000 France 2,000 00001 Germany 5,100 Is this possible? Thank you very much for your help in advance. -Warren AFAIK it isn't possible but you could add an extra column with Release # & " " & Country and that would show both in the table.  SignatureHope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. > Please excuse me if this is a very simple question, however I can't > seem to figure it out: [quoted text clipped - 18 lines] > > -Warren Thanks very much for your help. I'll try this out and see how it works. > AFAIK it isn't possible > [quoted text clipped - 27 lines] > > > > -Warren Hi Debra Dalgleish has some suggestions on ways to deal with this on her site at http://www.contextures.com/xlfaqPivot.html#Repeat SignatureRegards Roger Govier > Please excuse me if this is a very simple question, however I can't > seem to figure it out: [quoted text clipped - 18 lines] > > -Warren
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.