How to make Pivot

Question

Source

Parent CodeB/SVolumeBrokerageGSTStamp DutyAB1.008.008.001.00AS2.006.009.002.00BB3.004.003.003.00BS4.006.004.004.00CB5.00768.006.005.00CS5.006.001.006.00

Expectation

B   S   Row LabelsSum of VolumeSum of BrokerageSum of GSTSum of Stamp DutySum of VolumeSum of BrokerageSum of GSTSum of Stamp DutyA18812692B34334644C5768655616Grand Total978017911181412

Qiu · Accepted Answer

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

grazitti_sapna · Accepted Answer

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!