Multiple values in set expression

[#1]

Hi,

I have a variable, vYear=GetFieldSelections(Year) and a set expression using this variable -

Count({<Year={"$(=$(vYear))"}>}Distinct [Groups Key]).

The above set expression works when a single value is selected in the Year filter, but when I select multiple values in the filter the set expression returns null. Can anyone please guide me how to fix this expression ?

Appreciate your help !

Thanks,

Deepika

[pathiqvd]

Hi,

   Try This,

=count({<Year1=P(Year2)>} Distinct [Groups Key])

Year1 --> First table year field name take

Year2 --> Second table year field name take

Regards,