rank in dimensional reporting

[cognos05]

Hi guys,

I have a question related to using rank against a cube and i got the below code from other post .

rank(currentMeasure DESC tuple [Canada] WITHIN SET [ProductID])

Here instead of a single member [Cananda] , i have to use more than one country , say like [Singapore],[Canada],[US]

how the above expression can be replaced.

Thanks,

[Francis aka khayman]

this is just a shot in the dark. haven't done dimensional in a while. here goes nothing...


[rich ones] = set ([Singapore],[Canada],[US])

rank(currentMeasure DESC tuple [rich ones] WITHIN SET [ProductID])