Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Multi row/field formula (?) help

eyalyo
5 - 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

3 REPLIES 3
mheinze
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

RishiK
Alteryx
Alteryx

You beat me to it @mheinze 

eyalyo
5 - Atom

Worked perfect.

Thank you!

Labels