I have set up a pivot Table and would like to be able to group the dates in the filter list by Month
I have attached sample data
It would be appreciated if someone could kindly advise me
I have set up a pivot Table and would like to be able to group the dates in the filter list by Month
I have attached sample data
It would be appreciated if someone could kindly advise me
Change the format of the date column to Custom MMM
refresh the PT and check to make sure the change came through
If it didnt, remove the date field and then put it back in
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks for your advise
I created an extra column on the source sheet with end of month dates and formatted these as mmm-yyyy and used this as the filter data
OK, as long as that worked for you
thanks it did
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks