+ Reply to Thread
Results 1 to 3 of 3

Pivot Table: Move Metrics by Years Side-by-Side

  1. #1
    Registered User
    Join Date
    08-27-2006
    Posts
    48

    Pivot Table: Move Metrics by Years Side-by-Side

    I'm sure the title is confusing, but I wasn't sure how to say it.

    Essentially I have raw data with multiple metrics in columns, and dates in rows.

    - In the pivot table I am creating a group of months and years from the date.
    - I want the rows to be months and I want the years to be columns.
    - I want the metrics for each year to show side-by-side, which works fine if I have one metric.

    If I have more than one metric it places all the metrics for that year (2015), then all the metrics for 2016. Is it possible to get it to show each metric side-by-side for both years? I thought about moving the metrics to the column, then years underneath, but the column headers become the values of the metrics rather than the metric names.

    I know I can have the years as a row, under month, and that's the route I will go if necessary, but I would prefer them to be in columns.

    Thanks.

    David

  2. #2
    Registered User
    Join Date
    12-22-2015
    Location
    Huntsville, AL
    MS-Off Ver
    2007
    Posts
    92

    Re: Pivot Table: Move Metrics by Years Side-by-Side

    Can you post a sample workbook (with any proprietary information not included)?

  3. #3
    Registered User
    Join Date
    08-27-2006
    Posts
    48

    Re: Pivot Table: Move Metrics by Years Side-by-Side

    Quote Originally Posted by Cdubisms View Post
    Can you post a sample workbook (with any proprietary information not included)?
    My mistake. I meant to include it in my OP.
    Attached Files Attached Files

+ 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. [SOLVED] colourful bars side by side two years compare
    By makinmomb in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 01-05-2015, 01:21 PM
  2. Replies: 1
    Last Post: 07-23-2014, 11:53 PM
  3. putting columns side by side in a pivot
    By silentsisu in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-21-2014, 04:34 AM
  4. [SOLVED] Excel 2007 Pivot Table side by side row labels
    By arasan25 in forum Excel General
    Replies: 5
    Last Post: 03-13-2013, 05:21 PM
  5. [SOLVED] How to move data from right side to left side, please check the attachment
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-08-2013, 03:43 AM
  6. Replies: 0
    Last Post: 04-19-2009, 10:53 PM
  7. Replies: 1
    Last Post: 03-20-2006, 10:15 PM

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