Results 1 to 4 of 4

Thread: Single instance of column item in Pivot table

  1. #1

    Single instance of column item in Pivot table



    Register for a FREE account, and/
    or Log in to avoid these ads!

    OK so I have this planification sheet on classes and I need to figure out how busy the teachers will be. Here's the data I have:

    nb credits class will be given on class will be given again on class will be given again on
    class1 teacherA 2 1st trimester 2017 1st trimester 2018 1st trimester 2019
    class2 teacherB 3 2nd trimester 2017 1st trimester 2018 2nd trimester 2019
    class3 teacher A 1 1st trimester 2018 2nd trimester 2018 3rd trimester 2019

    And the data I'd like to get: (the numbers in the cells are the total of credits in this trimester)
    1st trimester 2017 2nd trimester 2017 3rd trimester 2017 1st trimester 2018 etc
    teacherA 2 0 0 3
    teacherB 0 3 0 3

    I'm currently using a Pivot Table, but the columns are listed twice (I have put the 'class will be given on', 'class will be given again on', etc. as columns).

    I can't seem to regroup them correctly, using the Grouping option. Any hints on how I could achieve this?

    Thanks

  2. #2
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,680
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Hi
    please post a sample sheet. Without that it's difficult to work on PT
    Thank you Ken for this secure forum.

  3. #3
    Here's the example. My main problem is to have multiple instances of the "same period of time" in the columns, and I can't group them properly. Thanks!
    Attached Files Attached Files
    Last edited by Pecoflyer; 2016-07-04 at 06:18 PM. Reason: Removed unnecessary quote

  4. #4
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,616
    Articles
    0
    Excel Version
    365
    You need to change the way your source data is arranged (Power Pivot might do this for you). See attached.
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •