Hello, I have a variant of the common stock problem. I have a cube to present the number of apples per store at any time, thus containing the time dimension (year, month, day), store dimension (city, store) and a measure Nr of Apples. The mdx for the calculated measure Nr of Apples is: (Tail(Filter(Descendants([Time].[Gregorian].CurrentMember,[Day]),Not ([Measures].[Nr of Apples]) =NULL),1).Item(0),[Measures].[Nr of Apples]) However, with the following data: "city" "store" "date" "nr of apples" F A 10-08-2005 10 F B 10-08-2005 5 F C 10-08-2005 15 F A 17-08-2005 15 F B 17-08-2005 F C 17-08-2005 10 something goes wrong. When I look at the nr of apples for city a on the year level of the time dimension it shows 25 (being the last known situation) correctly. However, when i drill down to store level it shows A: 15 (correct), B: 5(incorrect!!), C: 10 (correct). So what the formula does is taking the last known value for which it has data. But in this case i'd like it to take the value for the last known date. Does anybody have a solution?? Thnx in advance. Carlos