View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] braenovich.don@dol.gov is offline
external usenet poster
 
Posts: 5
Default 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