Getting data from previous row

Getting data from previous row

Hi,

I have a specific requirement to make using ZohoReports. It goes something like this:

If "Status" is 10 (row #2) and "Status" of previous row is 2 (row #1), subtract "StatusTime" (#2.StatusTime - #1.StatusTime) and put it in #2.DifferenceTime

How can I achieve this using Zoho reports?

Thanks!