Have a pivot table referencing a data table, and want to filter pivot on report date field. There are only 3 report dates in the table (hundreds of rows for each report date), but when i select the filter it shows every single day (1-Jan, 2-Jan, 3-Jan, 4-Jan, etc) instead of showing the 3 different possible report dates that exist in the data. When i move the report date field to the columns or rows section of the pivot table it shows the 3 report date groupings correctly. There are no blank cells in the report date field, all cells are valid date formatting. None are text stored as number. In the same workbook i have other pivot table referencing the exact same data table and the report date filter works correctly and only displays the 3 available report dates in the drop down. I've check every setting in the pivot and cant figure out what i must have unchecked or changed. Why/How is the filter showing dates that do not exist in the run date column, and why arent they only showing the 3 run dates??? What am i doing wrong??? Really driving me crazy. Any insight or help would be appreciated.
Bookmarks