Microsoft Office Tutorials and References
In Depth Information
Formatting the Pivot Report—Values and All
Figure 8–59. Numbers of sales, grouped by transaction size in dollars
True—you may need to think about this one. What we’ve done here is break out the number of
sales by the size of each sale , in sales intervals of $1,000. Thus, for example, there were 7 sales carried
out that were between $6012.50 and $7012.50, and 211 between £1012.50 and $2012.50. OK,
grantedthis was a tricky one: take the rest the day off (but before you do, note that grouped data may continue to
appear gr ouped on other new pivot r epor ts in the workbook, and so you may need to ungroup these
sooner or later in any case).
Formatting the Pivot Report—Values and All
Formatting a pivot report is pretty easy, because most of the options here reiterate the basic options
you’ve already learned. To format numbers, you can do one of two things: either right-click on any
value in the field you wish to format, select Value Field Settings on the resulting shortcut menu, and
then click Number Format , which is really little more than a tab on the good old Format Cells dialog
box that we ran into so often way back in Chapter 4 (Figure 8–60):
 
Search JabSto ::




Custom Search