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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

Multi-row Formula

Highlighted
Asteroid

Hi,

 

I have a scenario wherein, I need to populate the current cell with based on row+1. (The reverse of row-1).

 

Could you please help me on how to achieve it?

 

I have attached a sample attachment as well. 

 

Thanks,

Amit Belagali

Pulsar
Pulsar

@AmitBelagali Try sorting your data in the opposite way first using the Sort tool. Then fill down and then re-sort your data back to the original format.

Labels