Spreadsheet: 111022d1307543026-excel-2007-pivot-table-issue-ptwidgetfilter
Sheet: Data

 | Reference Number | Description | Quantity | Date
 | n/a | Widget 01 | 0 | 2011-05-19 00:00:00
 | n/a | Widget 02 | 0 | 2011-05-19 00:00:00
 | n/a | Widget 03 | 0 | 2011-05-19 00:00:00
 | Lab | Widget 04 | 15 | 2011-05-19 00:00:00
 | 5-13590 | Widget 05 | 5 | 2011-05-19 00:00:00
 | 5-13597 | Widget 05 | 3 | 2011-05-19 00:00:00
 | 5-13602 | Widget 05 | 2 | 2011-05-19 00:00:00
 | n/a | Widget 06 | 0 | 2011-05-19 00:00:00
 | n/a | Widget 07 | 0 | 2011-05-19 00:00:00
 | n/a | Widget 08 | 0 | 2011-05-19 00:00:00
 | 5-13602 | Widget 09 | 10 | 2011-05-19 00:00:00
 | n/a | Widget 09 | 0 | 2011-05-19 00:00:00
 | n/a | Widget 10 | 0 | 2011-05-19 00:00:00
 | n/a | Widget 11 | 0 | 2011-05-19 00:00:00
 | n/a | Widget 12 | 0 | 2011-05-19 00:00:00
 | n/a | Widget 01 | 0 | 2011-05-20 00:00:00
 | n/a | Widget 02 | 0 | 2011-05-20 00:00:00
 | n/a | Widget 03 | 0 | 2011-05-20 00:00:00
 | n/a | Widget 04 | 0 | 2011-05-20 00:00:00
 | 5-13602 | Widget 05 | 8 | 2011-05-20 00:00:00
 | n/a | Widget 06 | 0 | 2011-05-20 00:00:00
 | n/a | Widget 07 | 0 | 2011-05-20 00:00:00
 | n/a | Widget 08 | 0 | 2011-05-20 00:00:00
 | n/a | Widget 09 | 0 | 2011-05-20 00:00:00
 | n/a | Widget 10 | 0 | 2011-05-20 00:00:00
 | n/a | Widget 11 | 0 | 2011-05-20 00:00:00
 | n/a | Widget 12 | 0 | 2011-05-20 00:00:00
 | n/a | Widget 01 | 0 | 2011-05-23 00:00:00
 | n/a | Widget 02 | 0 | 2011-05-23 00:00:00
 | n/a | Widget 03 | 0 | 2011-05-23 00:00:00
 | n/a | Widget 04 | 0 | 2011-05-23 00:00:00
 | 5-13602 | Widget 05 | 5 | 2011-05-23 00:00:00
 | 5-13607 | Widget 05 | 5 | 2011-05-23 00:00:00
 | n/a | Widget 06 | 0 | 2011-05-23 00:00:00
 | n/a | Widget 07 | 0 | 2011-05-23 00:00:00
 | n/a | Widget 08 | 0 | 2011-05-23 00:00:00
 | 5-13602 | Widget 09 | 12 | 2011-05-23 00:00:00
 | n/a | Widget 10 | 0 | 2011-05-23 00:00:00
 | n/a | Widget 11 | 0 | 2011-05-23 00:00:00
 | n/a | Widget 12 | 0 | 2011-05-23 00:00:00
 | n/a | Widget 01 | 0 | 2011-05-25 00:00:00
 | n/a | Widget 02 | 0 | 2011-05-25 00:00:00
 | n/a | Widget 03 | 0 | 2011-05-25 00:00:00
 | n/a | Widget 04 | 0 | 2011-05-25 00:00:00
 | n/a | Widget 05 | 0 | 2011-05-25 00:00:00
 | n/a | Widget 06 | 0 | 2011-05-25 00:00:00
 | n/a | Widget 06 | 0 | 2011-05-25 00:00:00
 | n/a | Widget 06 | 0 | 2011-05-25 00:00:00
 | n/a | Widget 07 | 0 | 2011-05-25 00:00:00
 | n/a | Widget 08 | 0 | 2011-05-25 00:00:00
 | 5-13602 | Widget 09 | 6 | 2011-05-25 00:00:00
 | n/a | Widget 09 | 0 | 2011-05-25 00:00:00
 | n/a | Widget 10 | 0 | 2011-05-25 00:00:00
 | n/a | Widget 11 | 0 | 2011-05-25 00:00:00
 | n/a | Widget 11 | 0 | 2011-05-25 00:00:00
 | n/a | Widget 11 | 0 | 2011-05-25 00:00:00
 | n/a | Widget 12 | 0 | 2011-05-25 00:00:00
 | n/a | Widget 01 | 0 | 2011-05-26 00:00:00
 | n/a | Widget 02 | 0 | 2011-05-26 00:00:00
 | n/a | Widget 03 | 0 | 2011-05-26 00:00:00
 | n/a | Widget 04 | 0 | 2011-05-26 00:00:00
 | 5-13602 | Widget 05 | 2 | 2011-05-26 00:00:00
 | n/a | Widget 06 | 0 | 2011-05-26 00:00:00
 | n/a | Widget 07 | 0 | 2011-05-26 00:00:00
 | n/a | Widget 08 | 0 | 2011-05-26 00:00:00
 | n/a | Widget 09 | 0 | 2011-05-26 00:00:00
 | Colorado | Widget 10 | 45 | 2011-05-26 00:00:00
 | n/a | Widget 11 | 0 | 2011-05-26 00:00:00
 | n/a | Widget 12 | 0 | 2011-05-26 00:00:00
 | n/a | Widget 01 | 0 | 2011-06-01 00:00:00
 | n/a | Widget 02 | 0 | 2011-06-01 00:00:00
 | n/a | Widget 03 | 0 | 2011-06-01 00:00:00
 | n/a | Widget 04 | 0 | 2011-06-01 00:00:00
 | 5-13629 | Widget 05 | 20 | 2011-06-01 00:00:00
 | n/a | Widget 06 | 0 | 2011-06-01 00:00:00
 | n/a | Widget 07 | 0 | 2011-06-01 00:00:00
 | n/a | Widget 08 | 0 | 2011-06-01 00:00:00
 | 5-13602 | Widget 09 | 13 | 2011-06-01 00:00:00
 | n/a | Widget 09 | 0 | 2011-06-01 00:00:00
 | n/a | Widget 10 | 0 | 2011-06-01 00:00:00
 | n/a | Widget 11 | 0 | 2011-06-01 00:00:00
 | n/a | Widget 12 | 0 | 2011-06-01 00:00:00
 | n/a | Widget 01 | 0 | 2011-06-03 00:00:00
 | n/a | Widget 02 | 0 | 2011-06-03 00:00:00
 | n/a | Widget 03 | 0 | 2011-06-03 00:00:00
 | n/a | Widget 04 | 0 | 2011-06-03 00:00:00
 | 5-13630 | Widget 05 | 2 | 2011-06-03 00:00:00
 | 5-13629 | Widget 05 | 6 | 2011-06-03 00:00:00
 | 5-13656 | Widget 06 | 3 | 2011-06-03 00:00:00
 | n/a | Widget 07 | 0 | 2011-06-03 00:00:00
 | n/a | Widget 08 | 0 | 2011-06-03 00:00:00
 | n/a | Widget 09 | 0 | 2011-06-03 00:00:00
 | 5-13647 | Widget 10 | 3 | 2011-06-03 00:00:00
 | 5-13656 | Widget 11 | 3 | 2011-06-03 00:00:00
 | n/a | Widget 12 | 0 | 2011-06-03 00:00:00
 | n/a | Widget 01 | 0 | 2011-06-06 00:00:00
 | n/a | Widget 02 | 0 | 2011-06-06 00:00:00
 | n/a | Widget 03 | 0 | 2011-06-06 00:00:00
 | n/a | Widget 04 | 0 | 2011-06-06 00:00:00
 | 5-13656 | Widget 05 | 1 | 2011-06-06 00:00:00
 | 5-13629 | Widget 05 | 20 | 2011-06-06 00:00:00
 | n/a | Widget 06 | 0 | 2011-06-06 00:00:00
 | n/a | Widget 07 | 0 | 2011-06-06 00:00:00
 | n/a | Widget 08 | 0 | 2011-06-06 00:00:00
 | 5-13662 | Widget 09 | 8 | 2011-06-06 00:00:00
 | n/a | Widget 09 | 0 | 2011-06-06 00:00:00
 | n/a | Widget 10 | 0 | 2011-06-06 00:00:00
 | n/a | Widget 11 | 0 | 2011-06-06 00:00:00
 | n/a | Widget 12 | 0 | 2011-06-06 00:00:00
 | n/a | Widget 01 | 0 | 2011-06-07 00:00:00
 | n/a | Widget 02 | 0 | 2011-06-07 00:00:00
 | n/a | Widget 03 | 0 | 2011-06-07 00:00:00
 | n/a | Widget 04 | 0 | 2011-06-07 00:00:00
 | 5-13629 | Widget 05 | 35 | 2011-06-07 00:00:00
 | 5-13668 | Widget 05 | 4 | 2011-06-07 00:00:00
 | n/a | Widget 06 | 0 | 2011-06-07 00:00:00
 | n/a | Widget 07 | 0 | 2011-06-07 00:00:00
 | n/a | Widget 08 | 0 | 2011-06-07 00:00:00
 | 5-13662 | Widget 09 | 5 | 2011-06-07 00:00:00
 | 5-13668 | Widget 10 | 4 | 2011-06-07 00:00:00
 | n/a | Widget 11 | 0 | 2011-06-07 00:00:00
 | n/a | Widget 12 | 0 | 2011-06-07 00:00:00