I'm having trouble figuring out how to set up my PivotTable to filter by dates. The raw data I'm using has the following column heads:
Key | CellNum | Error Code | AITDate | Severity
The table is set up with Error Code as the column heads and CellNum as the rows. The data is a count of Key.
What I would like to do is be able to filter by a date range. If I add AITDate to the Page Area I can filter for a specific date but not for a range. Is there a way to filter for a date range?
Key | CellNum | Error Code | AITDate | Severity
The table is set up with Error Code as the column heads and CellNum as the rows. The data is a count of Key.
What I would like to do is be able to filter by a date range. If I add AITDate to the Page Area I can filter for a specific date but not for a range. Is there a way to filter for a date range?