calculate the sum of last 2 values in a column
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.