PDA

View Full Version : Single instance of column item in Pivot table



Audrey
2016-06-30, 08:34 PM
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

Pecoflyer
2016-07-01, 09:59 AM
Hi
please post a sample sheet. Without that it's difficult to work on PT

Audrey
2016-07-04, 03:54 PM
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!

p45cal
2016-07-05, 01:42 PM
You need to change the way your source data is arranged (Power Pivot might do this for you). See attached.