In a pivot table, you might want to see all the orders that were shipped on a specific date. To do that, you’d move the Ship Date field to the Page area, and select a date from the drop down list.

Sometimes though, you'd like to show the orders shipped in a date range, instead [...]