Insert a new row with sum of two rows in Load script

[Vamsi_T]

Hello All.

I would like to insert a new row ( sum of below rows) for every four rows in the data load script. Is this possible?

Kindly share the working solution...

Regards,

Vamsi

[Vamsi_T]

It's quite tricky. There are no other fields related to market share.

Using your solution, I sorted and grouped the field values in the Table. I need an additional column of the market share( sum/(Total (sum+A1), A2/(Total (sum+A1), A3/(Total (sum+A1).._ Cant we use grouping, group to generate market share?

[sunny_talwar]

Wait how did we get to market share from sorting? Are we still trying to address the sorting or is that done?

[Vamsi_T]

Sorting is done.   I just need a market share column.

My table values are in order, I am just giving hint that Cant we use grouping numbers(you created it for my initial question) to solve it.

[sunny_talwar]

Should be able to... give it a shot and let us know if it works or not