Start Free Trial

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
Top Solution Authors