+ Reply to Thread
Results 1 to 3 of 3

Is it possible to have individual columns act as a single data source for a pivot?

  1. #1
    Registered User
    Join Date
    06-23-2014
    Location
    Toronto
    MS-Off Ver
    2013
    Posts
    2

    Is it possible to have individual columns act as a single data source for a pivot?

    Okay, this might be a little difficult to explain. Hopefully you'll be able to following.

    I have an Excel sheet that's looking at a story backlog for a development project. For each story, I have 3 sets of story points. Each set of story points is mapped to a unique sprint schedule. For eample:


    STORY1 | 4 | SPRINT 12 | 6 | SPRINT 14 | 10 | SPRINT 11
    STORY2 | 2 | SPRINT 14 | 3 | SPRINT 11 | 7 | SPRINT 12

    Now I want to create a pivot that shows the sum of the story points for each sprint. I want it to look something like this

    SPRINT # | PLAN 1 | PLAN 2 | PLAN 3
    -----------------------------------------------------------
    SPRINT 11 | 20 | 13 | 20
    SPRINT 12 | 25 | 20 | 53
    SPRINT 13 | 15 | 34 | 23


    Is this possible without creating 3 separate pivots? If so, how do a 'group' (for lack of a better work) each of the story point columns with its matching sprint column? After that, I would imagine I'd need a way to tell Excel to treat the 3 sprint columns as containing the same data.

    I'm not sure if this is making any sense without seeing what I'm trying to do. Hopefully someone here understands what I'm getting at.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Is it possible to have individual columns act as a single data source for a pivot?

    You mention one column of data in the thread title but the sample data you posted appears to have multiple columns.

    How is your data structured?

    Can you upload an example workbook?

    Click on GO ADVANCED and use the paperclip icon to open the upload window.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    06-23-2014
    Location
    Toronto
    MS-Off Ver
    2013
    Posts
    2

    Re: Is it possible to have individual columns act as a single data source for a pivot?

    EDIT:

    I removed the attachment.

    I got the output I wanted by placing the pivots right next to each other and hiding the extra sprint columns.
    Last edited by vmhomeboy; 06-23-2014 at 01:45 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. Replies: 3
    Last Post: 03-28-2014, 01:36 PM
  2. [SOLVED] Multiple Pivot Tables - Single table of source data
    By some_evil in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-09-2014, 11:56 PM
  3. Replies: 2
    Last Post: 03-07-2013, 02:16 PM
  4. Hidden columns in pivot table source data
    By Kaigi in forum Excel General
    Replies: 2
    Last Post: 07-17-2009, 09:34 AM
  5. Replies: 5
    Last Post: 03-26-2009, 08:35 AM

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