Hi, I am trying to come up with the Median value (PIR_POR_DURATION) on the last 7 records in a table. The last 7 records would be qualified by date (most recent 7) and must have same Procedure and same Surgeon which are dimensions in my table/ And if possible I woul like to get this median value only after 10 records have been qualified, meaning there must be historical 10 records before taking the median value on the 7 most recent. I also am unsure whether I need the accumulation radio buttons in addition to the correct formula. I was trying something with RangeFractile based on my review of previous discusssions. I am fairly beginner on Qlikview. Any help would be much appreciated!! I have attached the output I am hoping to achieve. Notice only 2 procedures meet the 10 minimum requirement. If this part is too difficult, I would be happy with the median value on previous 7 cases (same surgeon, same procedure). Thank you!