 |
 | 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 / April 2008Excel pivot table grouping?
Hi - I;'m wondering if someone could give me a recommendation on this. Can I combine/pair/link two row labels together. here is my example... I need to show both the acct# and acct. name in a Pivot Table. Can I connect them somehow so they can display on the same row, rather then having them show as a row and sub-row. I've tried grouping - which doesn't seem to give me what I need. Any suggestions or recommendations? I'm using Excel 2007. Thanks in advance for your time and help!!!! Cindy B Could you not just concatenate them in a helper column and pivot that column?  SignatureHTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > Hi - > I;'m wondering if someone could give me a recommendation on this. Can I [quoted text clipped - 7 lines] > Thanks in advance for your time and help!!!! > Cindy B Thanks for your reply! I'm not sure what you mean by a helper column... Would I just create that as an new column on the spreadsheet, and then that column would be available for row labeling in the pivot table? I'll try that - and see how if I can get it to work.... thanks - again... SignatureCindy B > Could you not just concatenate them in a helper column and pivot that > column? [quoted text clipped - 10 lines] > > Thanks in advance for your time and help!!!! > > Cindy B That worked perfect.. can't believe I didn't think about that!!!! Thanks for helping me out!!!! SignatureCindy B > Could you not just concatenate them in a helper column and pivot that > column? [quoted text clipped - 10 lines] > > Thanks in advance for your time and help!!!! > > Cindy B > Hi - > I;'m wondering if someone could give me a recommendation on this. Can I [quoted text clipped - 6 lines] > Thanks in advance for your time and help!!!! > Cindy B I get my account numbers and account names to appear on the same row by just not having the account field set to subtotal - as there is a 1:1 relationship between accoutn number and account name this works fine. Regards Chris |
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.