+ Reply to Thread
Results 1 to 4 of 4

Looking for easy way to compare data over time - pivot?

  1. #1
    Registered User
    Join Date
    07-07-2014
    Location
    US
    MS-Off Ver
    Windows 7
    Posts
    10

    Looking for easy way to compare data over time - pivot?

    I have data for different service providers and the number of calls they take over different quarters of the year. I'd like to compare q1 from one year to q1 of another year. I keep thinking I should be able to use a pivot table, but when I look at tutorials, it doesn't seem to be the right kind of data set. Is there a way to filter or pull data from a single table and compare them, e.g., look at % increase or decrease from that same time period the year before? I've attached a table with call data. All pivot table tutorials that I've found relate to sales performance, but the data are too different from mine for me to be able to understand if that's the way to go.

    In plain English, here's what I want to do:
    at any given time, take data from a cumulative report, pluck 2 time periods and compare them. I know that I could set this up by formula but I'm looking to avoid creating yet another spreadsheet.

    Thanks,
    Sue
    Attached Files Attached Files

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Looking for easy way to compare data over time - pivot?

    The key is the layout of your data. The format your data is in already represents the output of a table.

    First, all columns require a header. Now make sure to arrange the data by commonality. Each row is a separate quarter, year, type, center, etc.
    Attached Files Attached Files
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Forum Contributor
    Join Date
    08-11-2004
    Posts
    109

    Re: Looking for easy way to compare data over time - pivot?

    You are looking for comparables from year to year per center? If so a pivot table is not your best resource. I would use formulas. Attached, I have changed the organization of your data to best explain the comparables per center. I know this is not exactly what you were looking for, but I hope it helps.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    07-07-2014
    Location
    US
    MS-Off Ver
    Windows 7
    Posts
    10

    Re: Looking for easy way to compare data over time - pivot?

    Thanks Dafodil11 and Mandy11. Both responses are very helpful.

+ 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. Compare two excels - Easy change between various documents
    By orjanmen in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-28-2014, 06:00 AM
  2. Multiple Pivot tables filter same data change template of all easy?
    By ThomasCarter in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-10-2013, 11:49 AM
  3. Replies: 4
    Last Post: 11-27-2012, 04:42 PM
  4. Replies: 2
    Last Post: 08-05-2010, 11:40 AM
  5. Replies: 0
    Last Post: 09-17-2009, 03:50 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