How to use Input Parameter in Restricted Column

[Former Member]

Dear All,

     Can anyone suggest me how to use input parameter in restricted column .

Since i have requirement to give Year (NVARCHAR) as input parameter and i want key figure one with the entered year and another one with less than the entered year.

Thanks in advance.

[Former Member]

Hi,

try to use not restricted, but calculated column:

if ("YEAR"<'$$VAR_YEAR$$',"MEASURE",0)