 |
 | 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 / November 2006Can't use calculated field for row or column area in Beta 2007
When a new calculated field 'calcfield' is created, a 'SIGMA values' is added to the column-labels-area, and a 'sum of 'calcfield' is added to the values-area. But I want to use the new field in the row-labels-area, and it is impossible to move the new field to that destination. When I read books about Pivot tables for Excel 2003, it looks like the calculated fields should behave like other fields in this respect. Do I see over some checkmark? When you create a calculated field in Excel 2003, it can only be placed in the data area. If there are multiple data fields, you can view them horizontally, or vertically. To change the orientation, drag the Data button into the column area or row area. > When a new calculated field 'calcfield' is created, a 'SIGMA values' is > added to the column-labels-area, and a 'sum of 'calcfield' is added to [quoted text clipped - 7 lines] > > Do I see over some checkmark?  SignatureDebra Dalgleish Contextures http://www.contextures.com/tiptech.html So when variables are needed to group data based on a calculation based on a date (like weeknum, month, workingday, weekend etc) those should be located as formulas in the original data-table? What is then a good way to replace the 'hard' data while keeping formulas and a references intact? I tried some solutions but one time the links were broken, another time I couldn't use import into the table. Gert Kok > When you create a calculated field in Excel 2003, it can only be placed > in the data area. [quoted text clipped - 14 lines] >> >> Do I see over some checkmark? Weeknum, working days and weekends could be calculated in the source data. Month could be created by grouping dates in the pivot table. I don't understand the rest of your question. > So when variables are needed to group data based on a calculation based > on a date (like weeknum, month, workingday, weekend etc) those should [quoted text clipped - 26 lines] >>> >>> Do I see over some checkmark? SignatureDebra Dalgleish Contextures http://www.contextures.com/tiptech.html The problem was how to refresh the 'real' data, while keeping the cells with formulas synchronised, whether there were more or less new data rows in a new dataset. Of course that's why the 'refresh' command was invented for tables... Thank you for the tips > Weeknum, working days and weekends could be calculated in the source > data. Month could be created by grouping dates in the pivot table. [quoted text clipped - 32 lines] >>>> >>>> Do I see over some checkmark? So when I want to group data on a calculation on a date (like weeknum, month, workingday, weekend etc) , I need variables who should be located as formulas in the original data-table? What is then a good way to replace the 'hard' data while keeping formulas and a references intact? I tried some solutions but one time the links were broken, another time I couldn't use import into the table. Gert Kok > When you create a calculated field in Excel 2003, it can only be placed > in the data area. [quoted text clipped - 14 lines] >> >> Do I see over some checkmark?
|
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.