Inside my raw data, there is a field for dates with the format of "mm-dd-yyyy". When generating the pivot table, the date is simply "mmmm". Where did the rest of the date field go?
ty
tim
Inside my raw data, there is a field for dates with the format of "mm-dd-yyyy". When generating the pivot table, the date is simply "mmmm". Where did the rest of the date field go?
ty
tim
Last edited by timstring; 06-10-2013 at 12:29 PM.
you should be able to format that field as a date - not sure why the format is changing like that
perhaps you attach a sample here for us to see
Here's the raw data:
here's the pivot table:Please Login or Register to view this content.
Please Login or Register to view this content.
you should be able to format that field within the pivot table
click on the field
field settings
Number button
should allow a format to a date format
I would if I could. The only thing in the "WorkDate" fields is "Jun"--no day or year.
can you attach a cut down version of the data and pivot table ?
Please see post #3
thats not the actual spreadsheet is it
so we can have a play
Here's the complete rows:
Please Login or Register to view this content.
thanks but i wanted it attached as a spreadsheet so I can actually manipulate in a pivot table
hope this helps
ProcessRouteParam.xlsm
click on workdate in the pivot report - cell E4
and then click on ungroup
and it changes to the correct format
its been grouped in the pivot table to show months and between a range of dates - if you click on the filter, you will see > and <
I think I solved my problem.
Click on "Supervisor" and click "collapse"
Last edited by timstring; 06-11-2013 at 10:12 AM.
OK , not sure I know enough about pivot tables to combine fields into 1 dropdown
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks