Hi ,
I have 2 groupby columns and I want to aggregate few columns based on the one group by column.For ex: i have a two sections of a class like section A & B under MPC(maths) and BIPC(biology) Groups.
Now i want to get total marks of both sections A & B under each group and display them as summary under each Group as shown below..
EX:
I want something like this.
Any help would be greatly appreciated.
Thanks.
Radha
I have 2 groupby columns and I want to aggregate few columns based on the one group by column.For ex: i have a two sections of a class like section A & B under MPC(maths) and BIPC(biology) Groups.
Now i want to get total marks of both sections A & B under each group and display them as summary under each Group as shown below..
EX:
|
Student ID |
Name |
Maths |
Science |
English |
||||
|
MPC(1st groupBy) |
||||||||
|
Section- A(2nd groupby) |
||||||||
|
1 |
Richards |
90 |
60 |
40 |
||||
|
2 |
Francisco |
100 |
50 |
30 |
||||
|
|
||||||||
|
Section- B |
||||||||
|
1 |
Richards |
90 |
60 |
40 |
||||
|
2 |
Francisco |
100 |
50 |
30 |
||||
|
Total MPC Marks: Maths:380 Chemistry:220 English:140 |
||||||||
|
B.I.PC |
||||||||
|
Section - A |
||||||||
|
1 |
Robert |
100 |
100 |
100 |
||||
|
2 |
Charles |
200 |
200 |
200 |
||||
|
Total B.I.PC Marks: Maths:300 Chemistry:300 English:300 |
||||||||
Any help would be greatly appreciated.
Thanks.
Radha
