create custom rollup formula | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

create custom rollup formula

I’ve created a custom rollup formula for the year and month level of time dimension as follows : [Time].CurrentMember.LastChild If is possibile i would like to create a custom rollup formula for the day level, so when i select multiple days i want to display the last value from the selected days. Can anyone help me?

You can accomplish this at any level of a time dimension using the PrevMember function in MDX.
([TIME].CurrentMember.PrevMember,[my measure]) In [my measure] I am refering to the value you want displayed.