community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Multi row/field formula (?) help

Atom

Hi,

Can someone assist with a way of duplicating the value in "Total" row to all other rows above?

Many thanks

 

14-07-2019 15-38-43.png

Highlighted
Alteryx
Alteryx

I would not use a multi-row formula for this. If you know the total will be the last row, I would use the same tool to select the last 1 row then append single row DIRECT LABOR data set to the original data set. 

 

SampleAppend.png

Alteryx
Alteryx

You beat me to it @mheinze 

Atom

Worked perfect.

Thank you!

Labels