How to find the data for only last 3 rows in a column. Please see description

Sprint               Sales

1                         100

2                         150

3                          125

4                         90

5                          300    

 

I wanted to find the value of only last 3 Sprints ie 5,4 and 1. so the sles total will be 125+90+300

whenever there is a new sprint added the formula should automatically fetch the last 3 sprints sum.

Kindly help.

 

Attached the spotfire file.

 

 

Attachments

AttachmentSize
Binary Data book2.dxp149.2 KB

(2) Answers

Login