Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Adding a new row and showing total of two rows

nirvapatel1998
7 - Meteor

Picture.PNG

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. 

 

1 REPLY 1
DataNath
17 - Castor
17 - Castor

@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.

 

DataNath_0-1660596622352.pngDataNath_1-1660596632751.png

Labels