Date field will not group in pivot table?

B

belletd3

I understand certain field sources will not group (such as some dates) but
how do you fix this problem?
 
F

Frank Kabel

Hi
normally they should group. Maye they are not date values but stored as
'Text'?
 
G

gatwickxx

I agree, dates should group. If your dates are not in Excel as a numbe
eg in a YYYYMMDD format, try converting this column into a number b
using a DATE function and use this column in your pivot table
 
J

JulieD

Hi

what sort of data do you want to group and how do you want it grouped? AFAIK
any "real" dates will group ("real" being dates recognised by excel as dates
and not entered as text).

Cheers
JulieD
 
D

Debra Dalgleish

If there are text entries, or blank cells in the date column, you won't
be able to group the field. If that's the problem, perhaps you could
delete any text, and add a "dummy" date to records with no date.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table grouping help 0
grouping dates in a pivot table 1
How to display zero value in blank fields of Cross Tab query 0
DATE Calculations in pivot table 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot table 0
Dealing with a Pivot Table (when I don't want to) 0
Copy previous record into form field 0

Top