pivot table convert dd/mm/yyyy to mm/yyyy

**timxiao** · 10-25-2011, 03:34 AM

hi, the original data is in dd/mm/yyyy, can only show mm/yyyy in piovt table? I tried group by month by the same month in two different has been mixed up

as attached pics shown
please help on this, thanks,

**arthurbr** · 10-25-2011, 03:52 AM

Hi and welcome to the board

Please post sample sheets instead of pictures - Thx

**timxiao** · 10-25-2011, 04:15 AM

Originally Posted by arthurbr

Hi and welcome to the board

Please post sample sheets instead of pictures - Thx

I want to do the same date as shows on 'date' and there are lots of skus didn't show up on the 'date' after I delete the description.

thanks,

**romperstomper** · 10-25-2011, 04:32 AM

Group by year as well as month. See attached.

**timxiao** · 10-25-2011, 04:36 AM

en~~~~~~~~~~~ I try to do the exactly same as 'data' shows, thanks anyway

**romperstomper** · 10-25-2011, 04:50 AM

Can I ask why, since the one on Date is wrong - it has been manually filtered to only show one of each date and hence the totals are inaccurate.
If you really want to reproduce that layout with the month and year in the same cell, you will need to add a formula to the underlying data that converts all the dates to a common day of the month (e.g. the first) and then group on that column rather than date.

**romperstomper** · 10-25-2011, 05:00 AM

This is the date pivot table with data corrected.

**timxiao** · 10-25-2011, 05:05 AM

I see, I just don't know how to do like this - nobody knows in my company now I understand why the date wasn't correct!! thanks a lot!!

**romperstomper** · 10-25-2011, 05:12 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

**timxiao** · 10-26-2011, 02:21 AM

cool~! Thanks again~!!

Thread: pivot table convert dd/mm/yyyy to mm/yyyy

Thread Tools

Display

pivot table convert dd/mm/yyyy to mm/yyyy

Re: pivot table convert dd/mm/yyyy to mm/yyyy

Re: pivot table convert dd/mm/yyyy to mm/yyyy

Re: pivot table convert dd/mm/yyyy to mm/yyyy

Re: pivot table convert dd/mm/yyyy to mm/yyyy

Re: pivot table convert dd/mm/yyyy to mm/yyyy

Re: pivot table convert dd/mm/yyyy to mm/yyyy

Re: pivot table convert dd/mm/yyyy to mm/yyyy

Re: pivot table convert dd/mm/yyyy to mm/yyyy

Re: pivot table convert dd/mm/yyyy to mm/yyyy

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions