M
Mick Henn
Hi,
I have created a pretty basic pivot table which pulls information from a
simple (but large) table.
The table is a list of queries which have come into my department, and it
contains columns for things like “issue categoryâ€, “date of issue†etc.
In my pivot table I want to be able to show the amount of queries which we
have received for each category over a given period. I can pull this
information however when I add the “Date of Issue†field to the report filter
area it looks like the pivot table doesn’t recognize that the data in this
field is actually a date. So when I try to filter it for a given time period
(a quarter for example) I cannot use the date filters which appear in the
table, I must select each individual date in the list as if it were a text
value?
I have formatted the entire “Date of Issue†column in the table to make sure
excel recognizes them all as dates and I can use the date filters in the
table but the pivot table report filter still doesn’t recognize them as dates.
Is this a problem anyone else has run into? If so I’d be grateful for any
tips on how to circumvent it.
Thanks in advance,
Mick.
I have created a pretty basic pivot table which pulls information from a
simple (but large) table.
The table is a list of queries which have come into my department, and it
contains columns for things like “issue categoryâ€, “date of issue†etc.
In my pivot table I want to be able to show the amount of queries which we
have received for each category over a given period. I can pull this
information however when I add the “Date of Issue†field to the report filter
area it looks like the pivot table doesn’t recognize that the data in this
field is actually a date. So when I try to filter it for a given time period
(a quarter for example) I cannot use the date filters which appear in the
table, I must select each individual date in the list as if it were a text
value?
I have formatted the entire “Date of Issue†column in the table to make sure
excel recognizes them all as dates and I can use the date filters in the
table but the pivot table report filter still doesn’t recognize them as dates.
Is this a problem anyone else has run into? If so I’d be grateful for any
tips on how to circumvent it.
Thanks in advance,
Mick.