Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have the following measure and it works correctly :
=valuelist( $(=concat(distinct chr(39) & MasterCalendar.Calendar_MonthStartDate & chr(39),',')) )
It is used to create dimension of one of my chart. So I get all the date depending of the filters applied to the table MasterCalendar or any other related table.
On top of that I would like to use the analysis set {1<MasterCalendar.year=$::MasterCalendar.year>} to get the same result without taking into consideration all filters applied except on the field MasterCalendar.year.
Unfortunatly I have not been able to integrate this piece of code in my dimension expression. Do you have any idea ?
Best
May be try -
{1<MasterCalendar.year=P(MasterCalendar.year)>}