In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

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 Alumni (Retired)

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

rkapoor
Alteryx
Alteryx

You beat me to it @mheinze 

eyalyo
5 - Atom

Worked perfect.

Thank you!

Labels
Top Solution Authors