Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Label Filter in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 pivot table label filter | Excel Discussion (Misc queries) | |||
Label Filter in Pivot Tab;e | Excel Worksheet Functions | |||
Pivot Table Label | Excel Worksheet Functions | |||
Pivot Table Label | Excel Discussion (Misc queries) |