How to Shift Data down by one row

[wumbo1]

I'm looking to shift data in the cells of a column down by one row like this: 

Original: 

What I'm trying to do: 

Is this possible in designer? 

[PhilipMannering · Accepted solution]

Perhaps this is one (of many) ways to do it....

[binuacs]

@wumbo1 Another way of doing this

[PhilipMannering]

@binuacs Oh, I like that better.

[christine_assaad]

Hi @wumbo1 

Is there a logic behind this operation?

I did it by basically splitting the columns. I added an empty text input and added it to your Value column to create the empty cell. I then joined the 2 columns based on position to shift the data down. Cheers!

[wumbo1]

@PhillipMannering

@binuacs

Thank you both of your for your responses. Both solutions work great. I also found that by creating a new field in the multi row formula, setting the "Values for Rows that don't Exist" parameter to 0 or empty, and putting [Row-1:Total NAV] has the same effect.