 |
 | 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 / Setup / November 2005PivotTable Contents
Hello- I'm REALLY new at pivot tables and need to get up to speed quickly. They seem very powerful, but I'm just starting. Could you tell me how to get actual data in the data fields? I just get counts. I want the actual data (names not count). This must be a simple format thing, I just can't find it. Thanks. I still need help on this one. If I go the "Field Settings", I can change count to sum or other math functions, but I want the actual text data NOT the count. (Like the salespersons name not the count of how many salespersons. I hope I'm clear on this, I really need help. Thanks. > Hello- > I'm REALLY new at pivot tables and need to get up to speed quickly. They [quoted text clipped - 3 lines] > This must be a simple format thing, I just can't find it. > Thanks. The stuff in the data area is quantitative/numbers. You can use labels in the row, column, page areas, though. > I still need help on this one. > If I go the "Field Settings", I can change count to sum or other math [quoted text clipped - 10 lines] > > This must be a simple format thing, I just can't find it. > > Thanks.  SignatureDave Peterson Don't drag it into a DATA area, drag it into a ROW field. If you suddenly get a whol eload of unwanted subtotals then simply right click one of them and choose 'none' under the 'automatic subtotals' field. SignatureRegards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- >I still need help on this one. > If I go the "Field Settings", I can change count to sum or other math [quoted text clipped - 10 lines] >> This must be a simple format thing, I just can't find it. >> Thanks. |
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.