+ Reply to Thread
Results 1 to 5 of 5

Pivot table last year comparison

  1. #1
    Registered User
    Join Date
    08-30-2018
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    3

    Pivot table last year comparison

    Hi all,

    Thanks in advance for your time reading through my query.

    I'm trying to make a comparative table from last year, month to month and country by country in a pivot table, but I can't do the format right. basically what I want is Last year above the current year and below a difference between both, instead of the sum of both years.

    I have attached an image just in case it makes it easier to understand. I'm trying to put the row with the dot, where the arrow shows.

    Has anyone got an idea on how to do it? Or should I use a simple table as I have been doing all this time?

    Thanks Screenshot (3)_LI.jpg

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    6,980

    Re: Pivot table last year comparison

    It sounds like you might be able to do this with some helper columns. We'd have to see the how the data are organized.

    Attach a sample workbook (not a picture or pasted copy). 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 then scroll down to Manage Attachments to open the upload window.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    08-30-2018
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    3

    Re: Pivot table last year comparison

    I think I have followed the steps correctly, hopefully it's properly attached.
    Attached Files Attached Files

  4. #4
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,580

    Re: Pivot table last year comparison

    With pivot, country in row label, fiscal year in column label & salesgbp in values.
    Refer attach file.
    Attached Files Attached Files


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  5. #5
    Registered User
    Join Date
    08-30-2018
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    3

    Re: Pivot table last year comparison

    Thanks a lot avk, that definetly works as I want, but the format is not what I was looking for, I would prefer the months to be columns and the the years under the countries, with the total difference right below. I presume that's not going to be possible?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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