How to make Pivot

[karantithi]

Source

Parent Code	B/S	Volume	Brokerage	GST	Stamp Duty
A	B	1.00	8.00	8.00	1.00
A	S	2.00	6.00	9.00	2.00
B	B	3.00	4.00	3.00	3.00
B	S	4.00	6.00	4.00	4.00
C	B	5.00	768.00	6.00	5.00
C	S	5.00	6.00	1.00	6.00

Expectation

	B				S
Row Labels	Sum of Volume	Sum of Brokerage	Sum of GST	Sum of Stamp Duty	Sum of Volume	Sum of Brokerage	Sum of GST	Sum of Stamp Duty
A	1	8	8	1	2	6	9	2
B	3	4	3	3	4	6	4	4
C	5	768	6	5	5	6	1	6
Grand Total	9	780	17	9	11	18	14	12

[Qiu · Accepted solution]

@karantithi 
We can use a Transpose and Cross Tab Combination as below

[grazitti_sapna · Accepted solution]

Hi @karantithi, Here is my input for the problem statement. I have created a dynamic workflow that will help in case a new field is introduced and will re-assign your fields as per expected output.

I hope this helps and please mark my post as a solution if it solves your purpose.

Thanks!

[karantithi]

Thanks Alot

[grazitti_sapna]

@karantithi Glad we could help!