My financial year runs 1st Feb to 31st Jan. I'm putting monthly sales data into a pivot table and filtering it by account so sales team members can see how their individual accounts are performing.
Straightforward stiff, problem is that the pivot chart shows Jan to Dec, not Feb to Jan like I need it to. Any ideas how to sort that?
Thanks
On a quick test it works correctly for me. Do you have the year on the months?
Maybe post your sample so we can look it over and spot the potential error/fix.
HTH
Regards, Jeff
On a quick test it works correctly for me. Do you have the year on the months?
Maybe post your sample so we can look it over and spot the potential error/fix.
Having played around with about every option I can find, under filter options it lets me drag months to wherever I like. That'll do for me.
Sounds good. Glad you found a workable solution...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks