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):