Hi, I have a summarized dataset which conatins 6 different products by their monthly sales. These 6 products belong to two different groups. ABC is group 1 and DEF belong to group2. It looks like this. Name Month1 Month2 Month3 A 10 10 10 B 20 20 40 C 40 30 20 D 30 40 60 E 10 50 50 F 20 60 30 I need to add rows to the data which sum up sales of all products in that group. It should look like this: Name Month1 Month2 Month3 A 10 10 10 B 20 20 40 C 40 30 20 SUM_ABC 70 60 70 D 30 40 60 E 10 50 50 F 20 60 30 SUM_DEF 60 150 140 Could anyone please tell me how should it be done? Thank you.
... View more