Microsoft Office Tutorials and References
In Depth Information
Counting Records: A Way to Break Out Text Data
Figure 8–23. The report filter for Dodsworth
This is an impressive option, but truly you could get away with one filter, and simply
click any particular salesperson when you need to. But if you need to break out each
salesperson’s data in separate sheets, the Report Filter Pages command is a worthwhile
one.
Counting Records: A Way to Break Out Text Data
Recall our introductory PivotTable example—that hypothetical dinner in which, among
other things, we wanted to tally the number of guests assigned to their tables. So how
would we go about constructing a PivotTable for this? Well, we want to break out the
number of guests by their table numbers, so the Table Number field will be posted in the
 
Search JabSto ::




Custom Search