Hi ,
can you assist with the format in the filter on the pivot table to be able to search by year and month. the dates are listed as individual dates as per attached screen shot. i would like to have in the "correct format" pic.
Regards
Rajeev
Hi ,
can you assist with the format in the filter on the pivot table to be able to search by year and month. the dates are listed as individual dates as per attached screen shot. i would like to have in the "correct format" pic.
Regards
Rajeev
by correct i assume you mean 2nd pic
if so this will help you
http://www.contextures.com/xlPivot07.html
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks