calculate the sum of last 2 values in a column

Hi All,

Please see attached dxp file with the data and issue.

I wanted t o calculate the sum for last 2 sprints, based on month. For january month sprint numbers are 1,2 and 3 and for Feb the sprint numbers are 3,4 and 5.

Whenever we select the month drop down, I wanted to calculate the sum of last 2 sprints based on project and Project type.

In case if there is any value missing for a particular sprint it should go and check for the next sprint.

example : for project "C" the sum(value)should be 15. Since the value is missing for sprint 4 it should calculate sprint 3 and sum it.



Binary Data testing_report.dxp157.03 KB

(3) Answers