高頓網校友情提示,*7上總結信息等內容公布如下:
  If you want to re-position the captions elsewhere, you can simply drag-and-drop the “∑ Values” field to another drop zone or another position in the drop zone that currently contains the “∑ Values” field. Say I wanted to see the labels above the “Year” field in the Column area. All I need to do is start dragging the “∑ Values” field, and I get feedback as to where the field will end up when I am done (blue bar, new cursor).
  如果您想把標題放到其它地方,您只需拖拽"∑ Values"字段到其它拖放區(qū)域或者已含有"∑ Values"字段的拖放區(qū)域的別的位置。也就是說當我要查看列區(qū)域中"Year"字段上面的標簽的時候,我所要做的就是拖動"∑ Values"字段,當我要放下(藍色邊,不一樣的鼠標指針)的時候就會看見字段豎起來。
  If I drag the “∑ Values” field above the “Year” field and let go, the PivotTable will refresh, and the captions will now be outside the year information, showing me a different view of my data. Here is what that looks like.
  如果我將"∑ Values"字段拖到"Year"字段上放下,透視表就會刷新,并且標題也會顯示出年度的信息,顯示出來的是一個不同的視圖。如下:
  I can also move the captions to the Row area. Here is what the PivotTable looks like when I have moved the “∑ Values” field to the bottom of the hierarchy on the Row area.
  我也可以將標題移動到行上。下面是當我移動"∑ Values"字段到行的底端相應級別時透視表的樣子:
  Further, I can move the captions anywhere else in the hierarchy in the Row area. Here is what the PivotTable looks like when I have moved the “∑ Values” field in between the Product Name and Product Category fields.
  而且,我可以在行的同級別里隨意移動標題。下面是我將"∑ Values"字段移到Product Name 和Product Category字段中間的樣子:
  By now you are probably getting the idea – the placement of the labels is infinitely flexible, allowing you to see the data pretty much any way you want. Hopefully folks see this as a useful feature. As always, I am interested to hear your feedback.
  現在你應該大概明白了——標簽的位置已經非常自由了,可以按照你希望的方式更精致的顯示數據。呵呵,這是一個非常有用的功能。
     
  掃一掃微信,學習實務技巧
   
  高頓網校特別提醒:已經報名2014年財會考試的考生可按照復習計劃有效進行!另外,高頓網校2014年財會考試高清課程已經開通,通過針對性地講解、訓練、答疑、模考,對學習過程進行全程跟蹤、分析、指導,可以幫助考生全面提升備考效果。