0
Range from a Selected Parameter Till Last Item in the Same Level the Parameter was Selected in
{[Customer Geography].[!@param@1] : TAIL({ [Customer Geography].[!@param@1].LEVEL.MEMBERS},1).ITEM(0)}
Where [Customer Geography].[!@param@1] is your parameter
@param@ is the parameter name.
This can also work for any other hierarchy, for example dates.
Range from the selected parameter date till current date.
{[Date].[Month Dates].[!@param@!] : TAIL({[Date].[Month Dates].[!@param@!].LEVEL.MEMBERS},1).ITEM(0) }
Like
Follow
Reply