filters allow you to filter the items in the list based on values in other fields. For example,
you can choose all customers where the sum of revenue is over $1 million. Or you can use
the Top 10 Filter to limit the pivot chart to the top five customers.
Every Axis and Legend field features a value filter. You will also see either label or date fil-
ters based on the type of data that Excel finds in the original column.
8
Chapter 8Creating and Using Pivot Charts
278
In order to see the date filters,all the values in the original column must be formatted as dates
when you create the pivot table.One single cell with a text value in a column of one million ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.