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,
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,
Last edited by timxiao; 10-26-2011 at 02:20 AM. Reason: solved!
Hi and welcome to the board
Please post sample sheets instead of pictures - Thx
Group by year as well as month. See attached.
Everyone who confuses correlation and causation ends up dead.
en~~~~~~~~~~~ I try to do the exactly same as 'data' shows, thanks anyway
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.
This is the date pivot table with data corrected.
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!!
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
cool~! Thanks again~!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks