How to shift the value of cells one step downward in tableau

I was asked to make a small change in the report to just move the data one step downward in a single column. This report is having multiple columns and I am required to move only the data of single column keeping the remaining data fixed in their respective places.

Initially the report used to look like the below:
I just need to shift the cells down by one step for the second column values. It can be done by using LOOKUP function. Need to create a calculated column as below:

Now replace the above column in the Measure Values card with the new calc field created which makes the report looks like below:

Its so simple!!!!!


No comments:

Post a Comment