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. 

[oliviamattea]

Thank you for this solution! It helped me a lot with a similar issue I had, although I found that my particular use case/dataset did not require the second union tool following the join tool. I'd be curious to know if there are specific cases in which this second union tool is required vs. not. 

[PhilipMannering]

@oliviamattea If you shift the data you're going to get misalignment by 1 record at the top and 1 record at the bottom. You would union to keep these records.