Morning - Power Pivot is in the middle of giving me fits.
I know the sorting function for monthly analysis is a pain, but any advice on this would be greatly appreciative.
I have 4 separate Pivot Tables within on sheet, which all relate back to a larger file.
Within each of these Pivot Tables, I have Customer #, NAme, Reps, etc, along with the Month and FY (I also have Month Name and Fiscal Yr, because I can't sort correctly). I have 2 problems currently.
1. I can't find the best way to get each pivot table to go from Jan FY 12, Jan FY 13, etc...to Jan FY 12, Feb FY 12, etc...Thought I had it one time, but I was kicked off server and now can't remember how it was done.
2. My pivot table needs to expand each month to add the next month - how can I do this? I always get the Pivot Table cant overlap error...
Any help or questions to make this better would be greatly appreciated.
Thanks,
Bookmarks