ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Pivot Table Label Filter (https://www.excelbanter.com/excel-worksheet-functions/453983-pivot-table-label-filter.html)

[email protected]

Pivot Table Label Filter
 
I have a spreadsheet of data tracking petition data. When a petition is completed a "PDO decision Date" is entered accordingly. I developed a pivot table and filter the data using a label filter as shown below. My date range is between 1/15/2018 and 1/19/2018. As you can see I get results outside of the date range why???? I have tried to determine the problem but I am striking out. What is the problem?


Docket
Number Status PDO Decision Date No. of Dockets
2014031 Granted Modification 1/16/2015 1
2014032 Granted Modification 1/16/2015 1
2015008 Dismissed Petition 1/19/2018 1
2015009 Dismissed Petition 1/19/2018 1
2016015 Granted Modification 1/16/2018 1
Grand Total 5


All times are GMT +1. The time now is 11:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com