+ Reply to Thread
Results 1 to 4 of 4

Placing same period side by side

  1. #1
    Forum Contributor
    Join Date
    05-17-2010
    Location
    Nigeria, Owerri
    MS-Off Ver
    Excel 2007 and 2013
    Posts
    254

    Placing same period side by side

    Good day all.
    Please I have a challenge that I need someone to help me out. I have a pivot table where dates are grouped in months. I want same periods of different years to be adjacent each other. For example, June, 2011 will be adjacent June, 2012, etc. Hope this since possible.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,453

    Re: Placing same period side by side

    Please post a sample sheet

  3. #3
    Forum Contributor
    Join Date
    05-17-2010
    Location
    Nigeria, Owerri
    MS-Off Ver
    Excel 2007 and 2013
    Posts
    254

    Re: Placing same period side by side

    Please I'm sorry to response late. I travelled to a local community that has no access to the internet.
    Below is the attachment.
    Attached Files Attached Files

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,453

    Re: Placing same period side by side

    In the Pivot Table Field list, drag the Transaction Date before the Years in the column labels

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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