+ Reply to Thread
Results 1 to 5 of 5

Is this possible with a Pivot table

  1. #1
    Forum Contributor
    Join Date
    10-25-2012
    Location
    london,england
    MS-Off Ver
    365 but on mac
    Posts
    137

    Is this possible with a Pivot table

    I currently compare the last 13 periods against a table - now I use pivot tables I see I can get them to sort in the same sequence. However I want this sequence to be dependant upon a starting date.

    Obvioulsy P4 today will be P5 in 4 weeks- I would like the pivot table result to count back from today period ( easy to set this by using a table ).

    I take todays week no. convert to a Period and then count back 13 periods from here including the year eg P1 2015 was proceeded by P13 2014

    Is this possible- i currently use index match but this is extrememly slow way of doing it will data tables and pivot results are far quicker

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Is this possible with a Pivot table

    It's not at all clear what you're asking, could you please attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  3. #3
    Forum Contributor
    Join Date
    10-25-2012
    Location
    london,england
    MS-Off Ver
    365 but on mac
    Posts
    137

    Re: Is this possible with a Pivot table

    Hi -apologies I should have thought - heres a basic look - I havent used pivot tables as I cant figure it out!


    moving periods.xlsx

  4. #4
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Is this possible with a Pivot table

    How do you determine the periods?

  5. #5
    Forum Contributor
    Join Date
    10-25-2012
    Location
    london,england
    MS-Off Ver
    365 but on mac
    Posts
    137

    Re: Is this possible with a Pivot table

    Week numbers 1 to 4 are always p1 4-8 p2 etc
    I usually vlookup against a basic table to give relevant p


    Sent from my iPhone using Tapatalk

+ 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: 6
    Last Post: 07-31-2014, 12:56 PM
  2. Collapse/Expand - Pivot table Fields - Need equivalent option in Excel VBA Pivot table
    By ragavendraph in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-07-2012, 03:00 PM
  3. Replies: 1
    Last Post: 06-22-2010, 09:10 AM
  4. Replies: 1
    Last Post: 06-20-2010, 04:00 AM
  5. Return pivot table range...not the data table, the PIVOT TABLE!
    By Air_Cooled_Nut in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-26-2008, 01:07 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