高頓網(wǎng)校友情提示，*7嘉興會計繼續(xù)教育網(wǎng)上總結信息Excel2007新知-透視表終曲_值字段技巧等內容公布如下：　　Pivot Tables grand finale: Tricks with the Values field
　　透視表終曲：值字段技巧
　　This is going to be the last PivotTable post, at least for a while. Unlike the last several posts, the subject matter that follows applies to any PivotTable, not just those connected to SQL Server Analysis Services.
　　這是本階段內最后一篇關于透視表的文章了。和前幾篇文章不同，本主題相關的應用不只是用于連接到SQL Server Analysis Services的,而是任何透視表。
　　In current versions of Excel, one of the capabilities that exist in PivotTables is the ability to adjust the position of the labels that describe the values in the Values region of the PivotTable (i.e. “Sum of Sales”). Excel PivotTables offer significant flexibility in this area – the labels can be on rows, on columns, and anywhere in the hierarchy on either of those areas. When we visit customers to talk to them about how they use PivotTables, though, we see a couple of things. First, the majority of users aren’t fans of our initial placement of the labels. Second, most people have never figured out that the labels can be repositioned. We have tried to address both of these items in Excel 12.
　　在這個版本的Excel中，透視表的一個功能就是，用于描述透視表（例如"Sum of Sales"）中選定范圍內值的標簽的位置是可以改變的。這一點上Excel透視表非常的靈活，標簽可以被放在行，列，或者那些區(qū)域層級的任意位置。當我們去客戶那里，告訴他們怎么使用透視表的時候，通常，我們會遇到兩種情況。一種是，大多數(shù)用戶不喜歡標簽的初始位置。另一種，多數(shù)客戶根本不知道這些標簽是可以移動位置的。我們已經(jīng)試著在Excel12中解決這些問題了。
　　This area is probably best explained by walking through an example, so here goes. To start with, imagine you were building the following PivotTable. It has some items on rows and columns, and Sales Amount summarized in the Values area.
　　看一個例子，應該是解釋這個問題的*4的方式，所以:),here goes。開始，想象一下你原來做下面這張表的時候。列和行上都有一些項目，后面的計算區(qū)域還有銷售統(tǒng)計額。
　　If you add a second field to the Values area – say Product Cost – then Excel adds some captions (“Sum of Sales Amount”, “Sum of Product Cost”) below the years (“2003”, “2004”) to help the user distinguish which numbers are Sales and which numbers are Product Cost.
　　當你增加另一個字段到數(shù)值區(qū)域，計算Product Cost，Excel就會在年度（"2003","2004"）下面加上標題（"Sum of Sales Amount","Sum of Product Cost"）以幫助用戶區(qū)別哪些數(shù)字是Sales哪些數(shù)字是Product Cost。
　　Those of you familiar with PivotTables have probably already spotted one change from current versions of Excel. In current versions of Excel, the captions are placed in the Row area, not the Column area. Here is a visual of what that looks like.
　　如果你熟悉數(shù)據(jù)透視表的話，也許已經(jīng)看出這個版本的Excel發(fā)生了什么改變了。在這個版本的Excel中，標題被放在了行首，而不是列。如下：
　　This one change – putting the labels on columns and not rows when a second field is added to the Values area – makes PivotTables with multiple items in the Values area more readable, and was the default positioning that most users wanted. So far, feedback on this one small change has been very positive.
　　當有更多字段被放在計算區(qū)域的時候，標簽將顯示在列上而不是行上，這樣的一個改變，使得有多個數(shù)值的透視表更具可讀性，并且，這也是大多數(shù)用戶想要的。到目前為止，這個小改變的反映非常良好。
　　As I said above, PivotTables are flexible enough to show the labels at any point in the hierarchy on either the Row or Column areas . To move the labels around in current versions of Excel, you can drag and drop a “Data” field in the Excel grid. This is not terribly obvious, though, and those folks that did spot this capability often had trouble putting the labels at the point in the hierarchy that they wanted. In Excel 12, we have tried to make this a more straightforward task by putting a field for the labels in the Drop Zone area of the field list that people can move around exactly like any other field. So, when you add more than one field to the Values area, we add a field labeled “∑ Values” to the field list, initially in the Column Label area.
　　如我上面說的一樣，現(xiàn)在的透視表已經(jīng)非常靈活，隨便你把標簽放在行還是列上了。在這個版本里，直接在Excel表格里拖拽"Data"字段就可以移動標簽了。對于那些經(jīng)常在移動標簽時遇到困難的用戶，這顯然是小菜一碟了。在Excel 12中，我們試著讓這個操作更加簡單，用戶只要為字段表的拖放區(qū)域中的標簽再寫一個字段，就可以像其他字段一樣隨便移動了。所以，當您增加一個或多個字段到數(shù)值區(qū)域的時候，我們就會在這些字段列表標簽的開頭加上"∑ Values"。
　　We don’t show this field until you add a second field to the Values area because we don’t put captions in the PivotTable until there are multiple items in the Values area.
　　當您在數(shù)值區(qū)域里放置第二個字段的時候字段標題才會顯示出來。這是因為我們不希望在透視表里加數(shù)值標題，除非里面有多個項目。
 　　　　
　　掃一掃微信，學習實務技巧
　　　
　　高頓網(wǎng)校特別提醒：已經(jīng)報名2014年財會考試的考生可按照復習計劃有效進行！另外，高頓網(wǎng)校2014年財會考試高清課程已經(jīng)開通，通過針對性地講解、訓練、答疑、模考，對學習過程進行全程跟蹤、分析、指導，可以幫助考生全面提升備考效果。