 |
 | 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 / General Excel Questions / May 2008Pivot Table showing number "1" instead of actual result
Hi I have a pivot table that I constantly update the data for but when this is refreshed on the cells that should show "Known As" I am seeing a number "1" instead . I have tried various ways around this by changing the data page to rename this to re-creating the data page but it is always an issue. Does anyone have any suggestions. Many Thanks in advance for your responses It sounds like you have the "Known As" field in the Data section of the Pivot Table Layout, instead of in the Row section. Consequently, you'd see the count of the item. Does that help? Regards, Ron Microsoft MVP - Excel > Hi > I have a pivot table that I constantly update the data for but when this [quoted text clipped - 6 lines] > Does anyone have any suggestions. > Many Thanks in advance for your responses |
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.