Ranking nested rows

[cognos05]

I have a Region and then EMployees under the region.

My column rank has the expression
Rank(currrentMeasure within set(Employees))

this ranks my all employees across all regions. I wan them to rank employees between their regions.

How should my expression look like,

Thanks,
Nithya

[cognos05]

Now the ranking is done based on  employees with all regions. But since I have nested employees under region.i wanted to rank the employees with respect to each region. can you guys let me know how to achieve this ..

thanks,
Nithya

[bdbits]

I am pretty sure you need to change your expression from using set(Employees) to the set() corresponding to the region.

[cognos05]

I did that and its not working.

[MFGF]

I did that and its not working.

What does "its not working" mean?

MF.

[cognos05]

Hi MFGF,
its not ranking it based on the employees with in regions.
IBM suggested the below code
rank(rank(currentmeasure within set ([Employee])) ASC for [Region])
but even this would work if I have only column and a measure.

Say if I have two columns like ytd and pytd and apply this then rank would not work.

WOuld not work is result being some random numbers ranked.

Thanks,
Nithya