+ Reply to Thread
Results 1 to 1 of 1

Comparing monthly sales over previous year along with year-over-year growth

  1. #1
    Registered User
    Join Date
    08-11-2020
    Location
    Canada
    MS-Off Ver
    Office for Mac 16
    Posts
    3

    Comparing monthly sales over previous year along with year-over-year growth

    Hi there,

    I have some sales data that is roughly:

    Date Customer Volume Product
    1/2/2022 A 5 1
    1/2/2021 B 3 1

    I'd like to get a monthly comparison over the same month last year, then a total year-over-year volume at the end. I tried a pivot table that has the following structure:

    Columns: Date, Year, Values
    Rows: Product
    Values: Volume, Volume2 (calculated field that is % difference from the previous year)

    It *mostly* works. I get Something that looks like the following

    Product Jan 2021 Diff from Jan 2020 (which I manually hide because there is no 2020 data) Jan 2022 Diff from Jan 2021 Total across months, regardless of year Total differences (?)
    1 3 5 66% 8

    I feel like I'm 90% there. What I need is to figure out:
    1) How the "grand total" at the end is actually a grand total by year, and the diff % is based on those totals
    2) Any way to automatically hide or skip the columns for which there is no comparison data?

    Thank you in advance!

    Edit: added a quick example file
    Attached Files Attached Files
    Last edited by jaybone; 03-29-2022 at 05:48 PM.

+ 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. How to best display year over year sales growth
    By manning457 in forum Excel General
    Replies: 3
    Last Post: 05-20-2015, 01:30 PM
  2. comparing sales turnover year on year
    By SuzyClifford in forum Excel General
    Replies: 2
    Last Post: 11-24-2014, 08:08 AM
  3. Excel 2007 - Comparison of monthly sales year on year
    By djr1970 in forum Excel General
    Replies: 7
    Last Post: 08-12-2014, 01:56 PM
  4. calculating year over year growth (with a twist)
    By jspinx in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-19-2010, 05:57 PM
  5. Replies: 1
    Last Post: 08-18-2010, 02:43 AM
  6. growth formula to predict sales for this year
    By ipodman in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-25-2007, 03:24 PM
  7. Replies: 0
    Last Post: 04-18-2006, 02:10 AM

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