Microsoft Office Tutorials and References
In Depth Information
Adding Data Fields
Figure 8–20. Dragging a field into the button area
On the othe r ha n d, i f y ou wa n t to remove a field from the report, all you have to is uncheck the box
next to that field’s name in the PivotTable Field List— or cl i ck on that fi e l d’ s button , an d dr ag i t towar ds
the worksheet proper. As you do, you’ll see an X accompanying the field name, and when you do, just
release your mouse to remove the field. Either way, the field will disappear from the pivot report. And
if you want to start over again and remove all the fields from the report, click PivotTable Tools
Options Tab Actions group Clear Clear All . The blank PivotTable grid will remain on screen,
however, enabling you to compose a new report right away. And as a matter of fact, let’s go ahead and
clear the report, because we want to start again and introduce a new report feature.
Adding Data Fields
So far, the pivot reports we’ve actually designed have called upon two source data fields, Order
Amount and Salesperson—and we’ve pivoted Order Amount to either the Row or Columns areas to
demonstrate how the same data can be portrayed differently. But you’ll recall that some of the demo
reports we’ve described feature three fields, such as the report captured in Figure 8–4, in which the
sales data were broken out both by Sal e spe r son an d Coun tr y , or the budg e t pi v ot r epor t, br oke n out by
both Date and Expense Type. With that in mind, click the checkbox by Country in the PivotTable Field
List. Then do the same for Salesperson and Order Amount. You’ll see (Figure 8–21):
Search JabSto ::

Custom Search