![]() |
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