Database Reference
In-Depth Information
FIguRe 5-20
Slicers on a worksheet
Formatting and Sorting Pivots
All the formatting is right at your fingertips. We have so many options to play
with here to dial in how we want this to work. Let's see the following few
figures, in which we can choose options and see the results of our formatting
capabilities in Excel.
The best way to experiment with formatting is to right click on columns in
your pivot table and select Format Cells. This will allow you to choose all
kinds of formatting options including currency, date formatting and other
customer formats like phone numbers, internal codes, etc. These options
will be covered throughout Part III of this topic in the Excel implementation
examples in each chapter.
You also have the option to do custom filtering on a pivot. Figure 5-21 shows
an option to filter by value.
