Return previous value of the group

0

Hello,

I own a report with grouping by date, and with a summation by date. I need the sum of the previous date for the calculation of the next date.

But have not found a way to busar the previous value, I tried to create a new variable, but the same always updated with the current value date of the group.

Could anyone help me?

Tiaguinho's picture
Joined: Feb 26 2014 - 4:06am
Last seen: 1 year 2 months ago

2 Answers:

0

check the running sum concepts in sql, it may helpful

Sukanya Parisa's picture
Joined: Dec 5 2013 - 10:29pm
Last seen: 3 years 7 months ago
0

Yes. I resolve this problem in the sql. The SQL retrieve all data and after calculate value.

thanks for the answer. :)

Tiaguinho's picture
Joined: Feb 26 2014 - 4:06am
Last seen: 1 year 2 months ago
Feedback
randomness