+ Reply to Thread
Results 1 to 5 of 5

Sorting FY in Power Pivot

  1. #1
    Registered User
    Join Date
    07-30-2014
    Location
    Columbus
    MS-Off Ver
    2013
    Posts
    64

    Sorting FY in Power Pivot

    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,

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Sorting FY in Power Pivot

    First, this is the PowerPoint forum, not PowerPivot.
    The sorting is a lot simpler if you can put the FY part before the month.
    You need to have blank rows and columns in between the pivot tables if you must have them on the same sheet. You can hide the excess blank rows and columns until they are needed.
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    07-30-2014
    Location
    Columbus
    MS-Off Ver
    2013
    Posts
    64

    Re: Sorting FY in Power Pivot

    haha - well, in reality I was only one letter off from being Pivot...

    THanks for the response - I'll hopefully get this figured out soon, big project due mid-week...

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,167

    Re: Sorting FY in Power Pivot

    Quote Originally Posted by spageopriya12 View Post
    Is there a way to sort on more than one column in a powerpivot table? For example, can I sort on the state column and then the Zip Code column. When I sort on the second column, the sort from the first column goes away. I'm curious to know if this is the way that it's suppose to sort - only on one column, or is there an option someplace that i am not aware of.
    You have committed two sins in this forum. You are blatantly linking to a commercial web site - I've removed the links in your original, and you are asking a question in the thread of someone else.

    Have you read the forum rules and is there any reason why you should not be sanctioned?
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  5. #5
    Registered User
    Join Date
    09-12-2016
    Location
    England
    MS-Off Ver
    2010
    Posts
    5

    Re: Sorting FY in Power Pivot

    Thanks................

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 06-19-2014, 12:59 PM
  2. Date formats in pivot tables using power pivot in Excel 2010.
    By myobreportguru in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-25-2013, 10:21 PM
  3. Power Pivot with multiple pivot charts using different pivot data
    By Paul-NYS in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-10-2013, 10:18 AM
  4. pivot table from Power Pivot not displaying thousand separator/comma
    By Paul-NYS in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-04-2013, 01:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1