Can We Get Value Of Above Cell Of Same Column Of Table In Ssrs Report Builder? How?

I have edited my question and replace the previous explanation with new one. I think I could't explain my problem clearly before. here is my scenario: Col1 |Col2 |Col3 |Col4 |

Solution 1:

Try Previous(Copy the expression used in your MyTextboxName)

Solution 2:

You can use Lag function in your SQL Statement to get to previous value.

SELECT Field1, Lag(Field1,1,NULL) OVER(PARTITIONBY .... ORDERBY ....)
FROM Table1..... 

Here are couple of articles to help you understand Lag in Detail

Intro to Lead and Lag By Pinal Dave

Lead and Lag function article in DatabaseJournal