In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Generate Rows Tool - Adding a Total Row

ebledsoe22
8 - Asteroid

Hello,

 

I am trying to add a total row to my data using the generate rows tool. Can this be done? Below is a screenshot of my data. I need the total to include all values with name that includes "Sum_". I think this is possible, but I think my loop expression needs some help. 

 

ebledsoe22_0-1673556137014.png

ebledsoe22_1-1673556168140.png

 

 

 

6 REPLIES 6
martinding
13 - Pulsar

Hi @ebledsoe22 ,

 

Is there any particular reason why you need to use the generate rows tool to calculate the row total?

 

You could try the following approach too.

Row Total.PNG

 

blingen
7 - Meteor

Hi @ebledsoe22 --

 

Please see attached workflow, one way to attack it! 

blingen_0-1673557851406.png

 

blingen
7 - Meteor

Oops--read it as column, not row! 

binuacs
21 - Polaris

@ebledsoe22 One way of doing this

 

binuacs_0-1673558664838.png

 

ebledsoe22
8 - Asteroid

My Ultimate goal is to sum the "Sum_" rows so that I can get a percentage of the total and then multiply those percentages by the value in row "A".

ebledsoe22
8 - Asteroid

Hi @blingen Thank you for this solution. This was actually very helpful because now I can create a ratio and then multiply by the correct cell using the multiple row formula tool. 

Labels
Top Solution Authors