Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

Help with totals using the multi-row formula

Highlighted
5 - Atom

Hi,

 

Is anyone able to help with creating a multi-row formula expression to create totals in a data set (I'm reluctant to use the Summarize tool as I want to keep the order of records).

 

Here's an example of what I'm trying to do, I'm trying to create totals for each 'Type'. I don't want to create a new field, just a new row.

liz1_0-1585257365162.png

 

Highlighted
14 - Magnetar

Multi-row wouldn't generate the output format in your example, since you're looking to generate 3 new rows. The best you can achieve with a multi-row would be a new column with a running total for each type. There is also a Running Total tool that can do this, but it is essentially a group and sum action like the summarize tool, so you might as well use summarize.

 

To preserve your row order, add a recordID first, then sort the records at the end. Something like this produces the format in your example.

 

DavidP_0-1585259034182.png

 

Highlighted
5 - Atom

Perfect, thank you so much.

Labels