Urgent Help : Rank On Nexted Rows OLAP Source

[Cognos KW]

Hi Gurus,

I am uusing cube as the source for creating report studio report. I have a requirement in which I need to show rank for the nested rows


P_Group |  Product      | Amount     Rank
___________________________________________
Product A | Product AA  |    20            1
               | Product AB  |    10            2
Product B | Product BA  |    45           1
               | Product BB  |     35           2
               | Product BC  |     25           3

I have tried rank function : rank (Amount within set P_Group) which shows blank and also tried rank (amount within set Product) which shows rank for all the products in a sequence without taking in considration P_Group. Can some one please guide me the right approch to this.

Urgent help needed.

Thanks in advance.

[HalfBloodPrince]

Not Sure abt wil this work in cube But give a try and let me know.

Group P_Group
Sort amount Descending
Create calculation Rank as running-count (1 for [P_Group] )

[Cognos KW]

Thanks for the report.

Its not working.