Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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,