Left Top is my input and bottom right is my desired output in Apteryx. Any suggestions of how I can insert rows and add the rows with common Group. Thank you in advance.
@nirvapatel1998 here's one way I can think of achieving this. I've included the final Formula tool to leave the names of the total rows blank, though if you'd prefer the '[Group] - Total' label that is used before that then you can simply delete the final tool. Let me know if there's any issues or if you need any further explanation/help.